Query Metrics
7
Database Queries
7
Different statements
195.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.59 ms (86.57%) |
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 350614 384336 386712 390713 412092 414068 414238 415005 431946 435358 444346 445751 447305 447480 447615 448405 448519 448878 449400 456730 459805 460346 462897 463819 463903 464030 468145 473598 477434 480454 483660 485151 487370 492040 494699 495399 497941 498973 501561 512378 512891 514799 515544 516524 516584 521895 524726 527358 527994 530214 540912 542385 543814 546682 548304 548733 550778 554098 555812 558144 560589 565320 565953 566925 567060 568787 572321 573694 573942 575123 577330 583856 584109 586605 586695 591280 593939 595412 597474 598076 604205 604372 604642 605713 618740 621087 622601 623716 624462 629124 629716 637046 637902 644954 684183 696126 701339 710009 712296 721745 722706 722916 737843 739949 741225 745707 746308 748119 748517 753994 764803 780062 784045 787768 789418 795353 795476 803576 811580 814643 ] |
||||||||||||||||||||||||||||||
|
16.92 ms (8.64%) |
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 448405 468145 463903 412092 521895 540912 568787 414068 435358 595412 586605 586695 514799 459805 527994 447305 386712 497941 463819 565320 555812 604372 445751 722706 554098 795476 543814 572321 696126 814643 460346 577330 524726 390713 449400 485151 637046 567060 448519 566925 565953 598076 495399 447615 483660 753994 447480 494699 621087 593939 737843 546682 591280 722916 501561 527358 710009 789418 477434 746308 487370 560589 480454 784045 780062 415005 684183 414238 530214 629124 629716 748517 462897 512378 498973 542385 622601 597474 573942 548304 795353 605713 456730 604205 473598 748119 516584 701339 741225 637902 548733 558144 764803 448878 644954 618740 573694 431946 584109 811580 739949 712296 583856 516524 623716 624462 550778 515544 444346 512891 787768 745707 721745 575123 350614 384336 604642 803576 464030 492040 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.26%) |
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 350614 384336 386712 390713 412092 414068 414238 415005 431946 435358 444346 445751 447305 447480 447615 448405 448519 448878 449400 456730 459805 460346 462897 463819 463903 464030 468145 473598 477434 480454 483660 485151 487370 492040 494699 495399 497941 498973 501561 512378 512891 514799 515544 516524 516584 521895 524726 527358 527994 530214 540912 542385 543814 546682 548304 548733 550778 554098 555812 558144 560589 565320 565953 566925 567060 568787 572321 573694 573942 575123 577330 583856 584109 586605 586695 591280 593939 595412 597474 598076 604205 604372 604642 605713 618740 621087 622601 623716 624462 629124 629716 637046 637902 644954 684183 696126 701339 710009 712296 721745 722706 722916 737843 739949 741225 745707 746308 748119 748517 753994 764803 780062 784045 787768 789418 795353 795476 803576 811580 814643 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls vagina"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк вагин"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.83%) |
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.