Query Metrics
7
Database Queries
7
Different statements
201.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.81 ms (87.36%) |
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 394760 397520 397901 398678 399522 400829 411580 417368 417665 422716 425513 426468 427064 427314 432526 433466 435537 436447 436693 441215 443300 443543 446742 447574 448578 449405 450442 453484 453802 454959 455574 456952 459225 459293 459654 463121 465116 466865 469452 472122 473229 473567 476329 478821 482262 484500 485264 485268 487502 489370 489409 489630 490566 490623 490752 494008 496537 499021 500010 504747 504751 504764 507648 508309 508743 510007 510665 513459 515889 516438 516492 516670 518081 518335 521470 521979 521984 522044 522311 523374 523476 524106 526518 527079 527687 529161 532027 535763 536913 542087 548842 551798 557669 565094 565861 567366 569962 571392 572898 574745 577899 587171 591940 599435 600395 600977 605758 608821 609432 618389 725408 727027 737098 737124 748662 756736 775372 796135 797119 804833 ] |
||||||||||||||||||||||||||||||
|
15.86 ms (7.88%) |
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 449405 456952 400829 422716 484500 490566 394760 441215 529161 551798 797119 737098 433466 476329 399522 482262 489370 521984 397520 485268 485264 523374 567366 600977 725408 417368 427064 436447 436693 417665 463121 398678 426468 454959 469452 453484 490623 521979 510665 489630 522311 513459 504764 518081 532027 557669 571392 587171 609432 618389 727027 748662 608821 459225 397901 425513 450442 446742 478821 432526 473567 459654 472122 500010 527687 487502 504747 516670 510007 518335 523476 499021 507648 516492 522044 524106 435537 443300 443543 427314 447574 448578 459293 465116 490752 515889 521470 535763 574745 542087 565094 565861 572898 548842 599435 737124 804833 796135 453802 411580 473229 527079 494008 496537 508309 489409 508743 455574 504751 526518 516438 536913 466865 577899 569962 591940 600395 605758 775372 756736 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.47%) |
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 394760 397520 397901 398678 399522 400829 411580 417368 417665 422716 425513 426468 427064 427314 432526 433466 435537 436447 436693 441215 443300 443543 446742 447574 448578 449405 450442 453484 453802 454959 455574 456952 459225 459293 459654 463121 465116 466865 469452 472122 473229 473567 476329 478821 482262 484500 485264 485268 487502 489370 489409 489630 490566 490623 490752 494008 496537 499021 500010 504747 504751 504764 507648 508309 508743 510007 510665 513459 515889 516438 516492 516670 518081 518335 521470 521979 521984 522044 522311 523374 523476 524106 526518 527079 527687 529161 532027 535763 536913 542087 548842 551798 557669 565094 565861 567366 569962 571392 572898 574745 577899 587171 591940 599435 600395 600977 605758 608821 609432 618389 725408 727027 737098 737124 748662 756736 775372 796135 797119 804833 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brother sex"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"brother секс"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"brother секс"
]
|
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.