Query Metrics
7
Database Queries
7
Different statements
162.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.50 ms (85.71%) |
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 365546 398508 398652 398674 411213 412238 413135 423839 424284 426794 427233 434839 435732 436343 441804 442164 442472 456147 459073 465205 467999 469957 476637 486423 487431 489813 489863 501105 506978 508104 514627 518383 522715 524787 525867 527437 529500 540729 556703 556716 557202 558865 558872 560101 564652 564928 582780 583821 594632 595063 619720 621601 623672 624961 624971 626170 627656 627754 627758 631583 634892 635125 639197 645267 645391 671193 673484 673506 697527 699892 709643 717615 720010 723713 723817 728667 734445 735307 735410 740220 753099 762329 763946 768983 772523 773463 773501 776189 779688 779721 783146 783584 783943 784356 786355 787312 787579 787605 789120 791263 791927 793237 793589 793700 795033 799446 800953 801182 803415 804053 807464 809462 811243 814090 814974 819372 823361 825704 827318 ] |
||||||||||||||||||||||||||||||
|
13.42 ms (8.24%) |
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 735410 735307 819372 634892 789120 723713 753099 442472 427233 514627 558865 709643 635125 740220 723817 720010 673506 627754 627758 786355 424284 814090 624961 783584 768983 442164 524787 627656 799446 776189 772523 787312 787605 763946 784356 787579 506978 779688 793237 773463 645391 699892 556716 594632 779721 791263 800953 728667 793700 734445 728648 564652 783943 435732 717615 823361 793589 804053 807464 809462 398674 783146 441804 518383 476637 501105 456147 486423 465205 814974 773501 487431 827318 527437 673484 621601 626170 582780 560101 795033 529500 525867 671193 645267 624971 639197 697527 436343 558872 801182 426794 411213 489863 365546 619720 459073 508104 623672 557202 564928 803415 791927 423839 825704 631583 467999 398508 434839 413135 583821 595063 811243 762329 398652 469957 489813 412238 540729 522715 556703 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.62%) |
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 365546 398508 398652 398674 411213 412238 413135 423839 424284 426794 427233 434839 435732 436343 441804 442164 442472 456147 459073 465205 467999 469957 476637 486423 487431 489813 489863 501105 506978 508104 514627 518383 522715 524787 525867 527437 529500 540729 556703 556716 557202 558865 558872 560101 564652 564928 582780 583821 594632 595063 619720 621601 623672 624961 624971 626170 627656 627754 627758 631583 634892 635125 639197 645267 645391 671193 673484 673506 697527 699892 709643 717615 720010 723713 723817 728667 734445 735307 735410 740220 753099 762329 763946 768983 772523 773463 773501 776189 779688 779721 783146 783584 783943 784356 786355 787312 787579 787605 789120 791263 791927 793237 793589 793700 795033 799446 800953 801182 803415 804053 807464 809462 811243 814090 814974 819372 823361 825704 827318 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"passionate sex"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"passionate секс"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"passionate секс"
]
|
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.