Query Metrics
7
Database Queries
7
Different statements
139.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.09 ms (84.96%) |
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 546304 586020 588223 588915 597218 597431 600818 601468 610441 612787 615075 616845 616912 618181 622677 622801 626135 626623 626655 627928 631551 631884 632209 634411 635034 636151 639680 643282 645045 660324 681246 687850 690222 693022 693668 698226 701243 701315 705010 708317 708704 710868 712624 713467 717423 724009 726041 728963 729985 732162 733284 735177 735373 736330 736365 736976 737933 740289 740960 741765 742052 742504 744073 746181 747260 747791 749598 750030 750638 750864 753645 753971 755601 756387 756682 756908 757444 758753 760331 760758 760974 761151 761161 761629 761643 761896 762827 763836 764142 764832 765502 769267 771260 771483 778417 781496 782696 783457 783649 785626 786719 789118 789591 789604 790830 791118 792034 793068 793599 793795 796724 796795 797064 800407 801547 802147 806240 811188 811449 ] |
||||||||||||||||||||||||||||||
|
11.28 ms (8.12%) |
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 712624 717423 645045 660324 681246 687850 690222 693022 693668 698226 708704 710868 546304 586020 588223 597218 616845 622801 626655 631884 636151 626135 632209 635034 597431 601468 610441 612787 616912 626623 627928 588915 600818 618181 631551 639680 643282 778417 782696 785626 786719 789591 789604 790830 792034 793795 796795 811188 776183 781496 789118 791118 793599 796724 797064 801547 806240 811449 744073 746181 749598 755601 756908 758753 760758 761629 783457 783649 793068 800407 802147 726041 735373 750638 760331 763836 764832 765502 769267 771260 771483 724009 732162 740289 741765 742504 747260 753971 756387 761896 764142 728963 729985 733284 736330 736365 742052 750864 753645 756682 760974 761151 761161 762827 735177 736976 737933 740960 747791 750030 757444 761643 615075 622677 634411 701243 701315 705010 708317 713467 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.87%) |
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 546304 586020 588223 588915 597218 597431 600818 601468 610441 612787 615075 616845 616912 618181 622677 622801 626135 626623 626655 627928 631551 631884 632209 634411 635034 636151 639680 643282 645045 660324 681246 687850 690222 693022 693668 698226 701243 701315 705010 708317 708704 710868 712624 713467 717423 724009 726041 728963 729985 732162 733284 735177 735373 736330 736365 736976 737933 740289 740960 741765 742052 742504 744073 746181 747260 747791 749598 750030 750638 750864 753645 753971 755601 756387 756682 756908 757444 758753 760331 760758 760974 761151 761161 761629 761643 761896 762827 763836 764142 764832 765502 769267 771260 771483 778417 781496 782696 783457 783649 785626 786719 789118 789591 789604 790830 791118 792034 793068 793599 793795 796724 796795 797064 800407 801547 802147 806240 811188 811449 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife ass fucked"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен жоп fucked"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен жоп fucked"
]
|
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.