Query Metrics
7
Database Queries
7
Different statements
187.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.83 ms (85.31%) |
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 14389 61168 81637 210661 223442 239112 311853 339474 381811 381924 385304 387186 388919 392967 395999 396542 396989 400138 402373 408558 431730 452444 457789 475187 476426 486589 488560 490060 495738 504252 504279 507309 511011 519242 522532 536211 543376 544713 547983 548788 549273 549307 549884 554841 557937 557951 563407 563448 567997 568480 569134 577931 579598 582972 583715 604555 607113 622201 632010 633118 645493 645749 648984 649112 649127 650833 653712 661289 662966 663946 665406 667075 670488 671000 671747 672184 679067 680587 681682 686021 690000 692457 693164 697705 716017 718976 742604 742906 745311 746589 747145 756054 760774 760834 771358 775909 778372 782755 783790 784224 784442 786039 787757 787912 790654 797164 805705 807192 812293 812300 816922 817748 818447 820032 823252 825894 826230 827416 828299 ] |
||||||||||||||||||||||||||||||
|
18.84 ms (10.06%) |
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 718976 782755 805705 756054 667075 339474 823252 828299 536211 475187 544713 563407 579598 583715 547983 549273 554841 645749 662966 690000 697705 549884 633118 775909 812293 784224 787757 812300 760774 765461 771358 745311 746589 81637 388919 486589 507309 504252 476426 519242 604555 488560 567997 563448 607113 511011 557937 650833 522532 582972 820032 649112 742604 387186 385304 381811 381924 223442 816922 679067 680587 693164 670488 681682 671747 783790 786039 790654 787912 742906 760834 61168 210661 396989 14389 817748 818447 827416 653712 671000 692457 645493 648984 649127 661289 663946 665406 622201 784442 797164 311853 239112 747145 778372 402373 825894 826230 549307 716017 490060 495738 543376 577931 568480 632010 504279 457789 431730 548788 569134 400138 408558 452444 557951 392967 395999 672184 686021 807192 396542 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"threesome sex"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.09%) |
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 14389 61168 81637 210661 223442 239112 311853 339474 381811 381924 385304 387186 388919 392967 395999 396542 396989 400138 402373 408558 431730 452444 457789 475187 476426 486589 488560 490060 495738 504252 504279 507309 511011 519242 522532 536211 543376 544713 547983 548788 549273 549307 549884 554841 557937 557951 563407 563448 567997 568480 569134 577931 579598 582972 583715 604555 607113 622201 632010 633118 645493 645749 648984 649112 649127 650833 653712 661289 662966 663946 665406 667075 670488 671000 671747 672184 679067 680587 681682 686021 690000 692457 693164 697705 716017 718976 742604 742906 745311 746589 747145 756054 760774 760834 771358 775909 778372 782755 783790 784224 784442 786039 787757 787912 790654 797164 805705 807192 812293 812300 816922 817748 818447 820032 823252 825894 826230 827416 828299 ] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро секс"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс втро секс"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.79%) |
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.