Query Metrics
7
Database Queries
7
Different statements
148.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.98 ms (83.92%) |
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 391264 398008 400326 447587 449517 451298 452744 469768 494626 496952 511593 516057 517789 536878 558265 559334 559976 567618 573062 576475 577836 583263 583795 588354 590103 592869 596533 606379 612144 612787 614063 615411 616438 617496 624021 624232 624274 635228 635527 635604 636628 641812 642134 643458 644072 645728 650669 655841 662097 672844 677227 680517 680664 684893 689462 690217 691454 698782 698785 698809 700382 703968 708743 710237 722963 725240 725251 729034 734295 738127 740960 741199 742824 743980 744074 744388 745472 745742 747254 748379 748642 749137 750328 752430 755330 756682 761354 761368 761872 762033 762442 764205 767335 769051 769137 776352 777198 777731 777935 778482 780284 782684 785975 787583 787979 790216 791656 794417 795635 797918 802352 804300 809343 809813 810066 813034 815085 815091 820122 825439 ] |
||||||||||||||||||||||||||||||
|
13.77 ms (9.24%) |
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 496952 655841 684893 690217 689462 710237 614063 782684 725251 787583 725240 734295 745472 747254 762442 764205 794417 809343 809813 398008 452744 558265 742824 577836 672844 635527 635604 612787 624021 643458 795635 743980 785975 744388 756682 740960 700382 703968 776352 469768 698785 583795 761368 748642 791656 777198 573062 567618 596533 778482 790216 820122 815085 815091 511593 588354 748379 810066 752430 825439 729034 400326 583263 680664 636628 592869 802352 749137 762033 777731 451298 494626 559334 662097 645728 680517 691454 642134 644072 777935 797918 745742 761354 767335 624232 698782 698809 391264 804300 650669 677227 447587 590103 635228 761872 769051 576475 559976 708743 722963 641812 615411 616438 617496 606379 780284 769137 787979 744074 750328 449517 813034 738127 536878 741199 755330 517789 516057 624274 612144 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (2.04%) |
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 391264 398008 400326 447587 449517 451298 452744 469768 494626 496952 511593 516057 517789 536878 558265 559334 559976 567618 573062 576475 577836 583263 583795 588354 590103 592869 596533 606379 612144 612787 614063 615411 616438 617496 624021 624232 624274 635228 635527 635604 636628 641812 642134 643458 644072 645728 650669 655841 662097 672844 677227 680517 680664 684893 689462 690217 691454 698782 698785 698809 700382 703968 708743 710237 722963 725240 725251 729034 734295 738127 740960 741199 742824 743980 744074 744388 745472 745742 747254 748379 748642 749137 750328 752430 755330 756682 761354 761368 761872 762033 762442 764205 767335 769051 769137 776352 777198 777731 777935 778482 780284 782684 785975 787583 787979 790216 791656 794417 795635 797918 802352 804300 809343 809813 810066 813034 815085 815091 820122 825439 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy fuck"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy секс"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy секс"
]
|
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.