Query Metrics
7
Database Queries
7
Different statements
149.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.24 ms (78.53%) |
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 405176 405907 415819 418399 420760 443634 443659 445739 448033 458912 466355 467613 471596 474621 477885 482174 484069 486336 487087 490253 491659 491911 497590 508179 508180 508804 511753 512329 515186 515187 516590 519617 520714 521357 527625 528441 530763 530779 531204 532644 532912 533265 538774 538802 550629 550667 552588 558012 558432 567346 569837 572297 575139 575211 575802 576023 576080 576113 576966 579797 581663 582785 587864 588746 593487 596659 597112 597121 597832 600453 610694 611616 611739 627652 627749 631957 637731 644059 645141 649525 654503 655609 655647 656792 656984 657361 658418 659579 661303 678973 682537 696977 696978 699400 706269 715388 720163 750158 756845 761203 766982 774692 790754 791233 791351 819111 825522 ] |
||||||||||||||||||||||||||||||
|
21.72 ms (14.55%) |
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 511753 512329 491659 497590 508804 527625 538774 533265 654503 656792 657361 655609 658418 659579 610694 611616 597112 508179 530779 538802 575211 576023 582785 567346 682537 572297 576966 597121 600453 627749 445739 458912 477885 487087 491911 558432 819111 576080 486336 448033 520714 532912 558012 575802 575139 596659 637731 790754 521357 750158 715388 766982 550629 597832 593487 466355 627652 699400 484069 508180 531204 482174 552588 649525 415819 696978 645141 791233 530763 655647 656984 515186 579797 720163 696977 581663 569837 611739 587864 515187 443634 588746 761203 774692 405907 756845 791351 405176 528441 576113 532644 519617 420760 644059 631957 825522 516590 706269 471596 490253 661303 443659 678973 474621 418399 467613 550667 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.86%) |
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 405176 405907 415819 418399 420760 443634 443659 445739 448033 458912 466355 467613 471596 474621 477885 482174 484069 486336 487087 490253 491659 491911 497590 508179 508180 508804 511753 512329 515186 515187 516590 519617 520714 521357 527625 528441 530763 530779 531204 532644 532912 533265 538774 538802 550629 550667 552588 558012 558432 567346 569837 572297 575139 575211 575802 576023 576080 576113 576966 579797 581663 582785 587864 588746 593487 596659 597112 597121 597832 600453 610694 611616 611739 627652 627749 631957 637731 644059 645141 649525 654503 655609 655647 656792 656984 657361 658418 659579 661303 678973 682537 696977 696978 699400 706269 715388 720163 750158 756845 761203 766982 774692 790754 791233 791351 819111 825522 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cuckold teen"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куколд teen"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куколд teen"
]
|
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.