Query Metrics
7
Database Queries
7
Different statements
177.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.15 ms (87.01%) |
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 6739 385380 388150 397014 407339 411534 415556 424216 429777 443160 443947 459638 460193 467360 494760 497840 504214 504862 510045 526272 528349 536447 537237 549393 550242 555058 555103 556647 559467 564578 564682 577599 579227 587205 601905 611285 622801 624209 625435 646664 648183 654187 668605 695107 696599 697192 705449 708164 714784 718650 719862 720588 720635 724194 725490 727087 732556 736336 740476 741785 746547 748936 757655 761594 764383 765307 765341 768125 775733 775990 776072 776584 776642 784396 791506 791849 793113 793138 793907 794411 794859 795180 795191 795574 795998 796126 796157 796207 796440 796920 797043 798477 799717 802414 802741 803082 803892 805645 807912 808438 811469 811655 813924 814333 815808 815844 817100 817373 819297 819505 819773 820060 821126 824253 824283 825254 826231 827431 ] |
||||||||||||||||||||||||||||||
|
13.79 ms (7.79%) |
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 795574 802414 397014 719862 555103 784396 695107 765307 815808 824283 817100 819773 815182 820060 494760 467360 564682 550242 654187 696599 697192 708164 720588 549393 776584 794859 797043 799717 811655 776642 811469 791506 795180 796157 808438 734834 768125 732556 757655 720635 796440 796920 805645 6739 429777 443947 705449 761594 795998 741785 796126 814333 510045 555058 601905 775733 724194 460193 424216 411534 817373 824253 819297 536447 559467 714784 668605 646664 611285 622801 624209 587205 776072 793907 746547 765341 794411 736336 740476 764383 748936 718650 791849 793138 798477 803892 415556 579227 385380 504214 526272 528349 796207 807912 775990 504862 556647 625435 727087 725490 802741 388150 407339 443160 815844 827431 819505 821126 825254 826231 813924 459638 497840 537237 577599 564578 648183 795191 793113 803082 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.43%) |
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 6739 385380 388150 397014 407339 411534 415556 424216 429777 443160 443947 459638 460193 467360 494760 497840 504214 504862 510045 526272 528349 536447 537237 549393 550242 555058 555103 556647 559467 564578 564682 577599 579227 587205 601905 611285 622801 624209 625435 646664 648183 654187 668605 695107 696599 697192 705449 708164 714784 718650 719862 720588 720635 724194 725490 727087 732556 736336 740476 741785 746547 748936 757655 761594 764383 765307 765341 768125 775733 775990 776072 776584 776642 784396 791506 791849 793113 793138 793907 794411 794859 795180 795191 795574 795998 796126 796157 796207 796440 796920 797043 798477 799717 802414 802741 803082 803892 805645 807912 808438 811469 811655 813924 814333 815808 815844 817100 817373 819297 819505 819773 820060 821126 824253 824283 825254 826231 827431 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf hard fuck"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf hard секс"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf hard секс"
]
|
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.