Query Metrics
7
Database Queries
7
Different statements
381.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.39 ms (54.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade public"
]
|
||||||||||||||||||||||||||||||
|
150.43 ms (39.45%) |
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 72889 76312 146523 219957 274100 348413 382514 385781 387299 392902 393157 418456 423963 424615 425007 427057 428446 430572 436481 439516 444053 445636 453584 455486 458635 458830 460891 462950 464046 465587 466365 466492 467072 469618 472366 477205 478008 484035 485560 486601 488692 491719 492495 495412 496646 497974 498434 501943 504220 506477 507755 512765 514045 516704 516961 518962 521953 525984 526153 526335 527814 530063 535664 549911 550475 551106 556493 561952 565020 569859 569874 569899 569911 570290 570646 571596 571612 572108 572818 573565 574043 575357 580993 583367 589357 590446 590461 598493 605691 611694 614989 624480 625050 627782 636155 637945 644151 666463 666614 675583 696342 696381 721958 722019 732154 738653 740966 757889 757908 769469 778265 782306 782813 787317 787563 788367 792690 801398 805109 827950 ] |
||||||||||||||||||||||||||||||
|
14.57 ms (3.82%) |
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 696381 605691 512765 488692 583367 486601 571612 427057 627782 625050 76312 485560 549911 792690 516704 504220 666614 387299 146523 464046 425007 465587 458635 382514 424615 561952 696342 526335 445636 385781 573565 458830 572108 788367 740966 769469 732154 418456 527814 580993 611694 637945 497974 787563 484035 598493 496646 423963 466492 675583 644151 467072 569859 569899 572818 590461 521953 570646 569911 721958 782813 472366 827950 569874 570290 72889 518962 274100 530063 462950 535664 551106 614989 348413 219957 782306 624480 430572 453584 516961 575357 556493 805109 787317 757889 722019 460891 492495 778265 525984 495412 526153 590446 506477 455486 466365 439516 514045 469618 436481 393157 428446 478008 507755 574043 491719 636155 477205 565020 666463 738653 501943 550475 392902 571596 589357 801398 757908 498434 444053 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (0.66%) |
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 72889 76312 146523 219957 274100 348413 382514 385781 387299 392902 393157 418456 423963 424615 425007 427057 428446 430572 436481 439516 444053 445636 453584 455486 458635 458830 460891 462950 464046 465587 466365 466492 467072 469618 472366 477205 478008 484035 485560 486601 488692 491719 492495 495412 496646 497974 498434 501943 504220 506477 507755 512765 514045 516704 516961 518962 521953 525984 526153 526335 527814 530063 535664 549911 550475 551106 556493 561952 565020 569859 569874 569899 569911 570290 570646 571596 571612 572108 572818 573565 574043 575357 580993 583367 589357 590446 590461 598493 605691 611694 614989 624480 625050 627782 636155 637945 644151 666463 666614 675583 696342 696381 721958 722019 732154 738653 740966 757889 757908 769469 778265 782306 782813 787317 787563 788367 792690 801398 805109 827950 ] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.