Query Metrics
7
Database Queries
7
Different statements
204.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
180.24 ms (88.21%) |
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 395530 396881 406645 411895 412007 416169 416277 418669 422262 424965 426003 427290 428161 428223 429275 430542 431393 431793 434259 443227 446856 448195 448744 448981 450764 450913 457915 460189 466786 466840 469726 475489 481039 481794 484012 486610 493247 494820 495617 497952 501204 507547 510423 512030 515711 521049 521698 522767 523796 524934 525660 527641 531473 532463 533174 535831 539828 560852 561470 562408 566068 575243 587927 590592 595003 600850 602407 603977 606617 606960 607202 611389 630782 633851 635280 637411 638566 645003 646395 650201 651006 664275 673124 682138 714883 718182 720522 747135 751560 756070 758601 765834 769547 771974 773000 779558 780407 784942 785139 786352 786831 790553 795511 800875 802533 804065 804071 805677 809668 812833 814349 815839 819082 820417 820938 821345 822623 823097 825545 827842 ] |
||||||||||||||||||||||||||||||
|
13.25 ms (6.48%) |
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 428161 434259 443227 422262 429275 821345 822623 823097 819082 815839 820417 820938 825545 827842 466786 481039 450764 460189 469726 539828 532463 533174 535831 650201 673124 664275 682138 646395 651006 720522 562408 595003 611389 635280 638566 600850 606617 633851 637411 630782 587927 779558 790553 800875 780407 784942 785139 786352 786831 812833 747135 758601 771974 773000 802533 804065 805677 765834 751560 606960 795511 426003 395530 406645 507547 525660 484012 431393 412007 718182 756070 416169 416277 427290 428223 645003 450913 521049 603977 769547 804071 448744 418669 448981 466840 430542 512030 522767 527641 521698 494820 497952 501204 814349 481794 523796 531473 448195 524934 714883 396881 431793 411895 457915 475489 607202 424965 510423 493247 495617 486610 515711 446856 560852 561470 566068 575243 602407 590592 809668 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.51%) |
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 395530 396881 406645 411895 412007 416169 416277 418669 422262 424965 426003 427290 428161 428223 429275 430542 431393 431793 434259 443227 446856 448195 448744 448981 450764 450913 457915 460189 466786 466840 469726 475489 481039 481794 484012 486610 493247 494820 495617 497952 501204 507547 510423 512030 515711 521049 521698 522767 523796 524934 525660 527641 531473 532463 533174 535831 539828 560852 561470 562408 566068 575243 587927 590592 595003 600850 602407 603977 606617 606960 607202 611389 630782 633851 635280 637411 638566 645003 646395 650201 651006 664275 673124 682138 714883 718182 720522 747135 751560 756070 758601 765834 769547 771974 773000 779558 780407 784942 785139 786352 786831 790553 795511 800875 802533 804065 804071 805677 809668 812833 814349 815839 819082 820417 820938 821345 822623 823097 825545 827842 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov milf beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов milf красивая"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов milf красивая"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.