Query Metrics
7
Database Queries
7
Different statements
420.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.05 ms (50.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
184.27 ms (43.85%) |
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 396684 399415 400903 403906 406291 417316 418920 419220 420315 422287 423243 423398 426016 426334 427869 428516 432086 439456 441933 448365 456365 457820 461845 462983 466820 473231 473375 475066 479449 494221 494648 500181 502289 503010 509729 514480 514779 525518 526394 539051 539372 542923 546373 547426 550088 552802 557924 558232 558801 561940 562497 562966 568076 578247 581987 582398 587885 588714 590064 591819 592571 602052 604042 605396 605587 606333 613778 613849 614045 619462 619501 626432 632102 638459 654596 661646 662431 667427 674907 679228 682270 692676 697201 715622 716522 716664 717930 721908 726496 726530 737179 739672 743128 744866 747943 750069 750078 751715 753181 760439 767683 775697 781927 781999 788377 789689 794104 794820 796209 796349 799435 800425 801387 802868 803087 803244 814521 820423 821149 ] |
||||||||||||||||||||||||||||||
|
15.89 ms (3.78%) |
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 514779 525518 514480 526394 557924 547426 654596 682270 590064 606333 767683 632102 423398 814521 667427 716664 605587 619462 739672 753181 539372 562966 619501 605396 396684 399415 406291 422287 423243 428516 418920 417316 432086 821149 820423 456365 461845 466820 448365 539051 500181 509729 494221 494648 502289 473375 479449 546373 552802 558232 558801 568076 542923 550088 582398 561940 578247 661646 674907 721908 679228 692676 697201 716522 717930 662431 562497 581987 587885 602052 613778 638459 592571 613849 614045 588714 604042 591819 775697 789689 794104 796209 800425 796349 799435 743128 744866 760439 788377 794820 803087 726496 726530 741919 747943 750069 750078 751715 737179 626432 715622 781927 781999 801387 802868 803244 403906 419220 439456 473231 426334 441933 400903 426016 462983 420315 427869 457820 475066 503010 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (0.73%) |
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 396684 399415 400903 403906 406291 417316 418920 419220 420315 422287 423243 423398 426016 426334 427869 428516 432086 439456 441933 448365 456365 457820 461845 462983 466820 473231 473375 475066 479449 494221 494648 500181 502289 503010 509729 514480 514779 525518 526394 539051 539372 542923 546373 547426 550088 552802 557924 558232 558801 561940 562497 562966 568076 578247 581987 582398 587885 588714 590064 591819 592571 602052 604042 605396 605587 606333 613778 613849 614045 619462 619501 626432 632102 638459 654596 661646 662431 667427 674907 679228 682270 692676 697201 715622 716522 716664 717930 721908 726496 726530 737179 739672 743128 744866 747943 750069 750078 751715 753181 760439 767683 775697 781927 781999 788377 789689 794104 794820 796209 796349 799435 800425 801387 802868 803087 803244 814521 820423 821149 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm out"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм out"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм out"
]
|
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.