Query Metrics
7
Database Queries
7
Different statements
173.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.62 ms (84.29%) |
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 7523 373741 382051 384304 388177 395975 398261 413685 413695 414201 417725 424564 430796 433216 448520 450690 450951 453355 453793 453825 453952 454628 455585 458299 463948 468069 468085 474994 478908 482079 489359 495824 497439 498548 501831 503468 504389 506299 510545 511739 511818 512419 514794 514995 516004 518995 520969 524002 525028 526259 526734 527589 530012 530795 532798 533660 534040 536264 536396 536674 536889 537669 537929 537987 548260 567769 568169 574571 574889 575060 575750 595497 596995 597041 597502 597560 598478 598479 598674 598679 603052 615148 620554 630266 641950 642781 653533 656562 657206 663232 666528 667129 681189 687560 690251 692085 701396 705840 709565 719937 719979 720397 720967 722538 726176 728404 730554 732262 748547 753259 753304 753327 753351 753388 753902 755677 770295 788248 795859 806332 ] |
||||||||||||||||||||||||||||||
|
16.95 ms (9.75%) |
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 511739 526734 527589 498548 504389 512419 514794 536396 489359 525028 518995 520969 524002 537929 453825 548260 653533 657206 690251 687560 692085 656562 667129 701396 705840 709565 720967 598479 597041 615148 597560 753351 726176 728404 753304 753327 755677 806332 641950 730554 373741 530012 536889 722538 603052 595497 795859 770295 497439 533660 681189 630266 482079 511818 501831 620554 495824 450690 503468 506299 666528 720397 753902 532798 530795 534040 575060 663232 574571 598674 598679 597502 642781 788248 732262 748547 719937 596995 598478 7523 384304 567769 575750 753259 753388 719979 395975 382051 388177 398261 413695 417725 430796 413685 414201 433216 424564 448520 450951 463948 468069 453355 453793 453952 455585 458299 454628 468085 536264 526259 537987 510545 516004 536674 514995 537669 474994 478908 568169 574889 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.59%) |
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 7523 373741 382051 384304 388177 395975 398261 413685 413695 414201 417725 424564 430796 433216 448520 450690 450951 453355 453793 453825 453952 454628 455585 458299 463948 468069 468085 474994 478908 482079 489359 495824 497439 498548 501831 503468 504389 506299 510545 511739 511818 512419 514794 514995 516004 518995 520969 524002 525028 526259 526734 527589 530012 530795 532798 533660 534040 536264 536396 536674 536889 537669 537929 537987 548260 567769 568169 574571 574889 575060 575750 595497 596995 597041 597502 597560 598478 598479 598674 598679 603052 615148 620554 630266 641950 642781 653533 656562 657206 663232 666528 667129 681189 687560 690251 692085 701396 705840 709565 719937 719979 720397 720967 722538 726176 728404 730554 732262 748547 753259 753304 753327 753351 753388 753902 755677 770295 788248 795859 806332 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen big dick"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.93%) |
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.