Query Metrics
7
Database Queries
7
Different statements
156.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.54 ms (84.06%) |
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 101773 388341 393921 394566 395784 414932 417278 427336 430542 441097 444880 456156 462538 464048 466899 470415 489195 495117 495293 496462 497843 501597 505462 505946 515340 522112 523212 523347 528744 542915 546588 550505 554850 556790 564625 568932 572719 574185 589583 591195 591832 596950 597670 598566 599401 600941 603817 604813 608512 608669 613335 615627 615686 617339 625134 625544 629821 640432 641485 650053 659349 665600 678724 678732 680030 688146 694585 694935 695140 697013 707196 712073 714211 714833 720066 727554 730144 733672 735974 736785 745243 749669 754078 757318 760227 762163 764077 767793 770348 773545 773813 775632 775754 779720 781584 782079 783670 784747 785255 785468 785967 786662 790084 790464 790568 791186 791394 791441 792420 794398 800242 801715 802059 804432 804682 806722 809195 810811 811785 817417 ] |
||||||||||||||||||||||||||||||
|
13.53 ms (8.65%) |
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 781584 785468 790084 794398 811785 767793 757318 764077 773813 735974 466899 462538 817417 542915 564625 556790 615686 523347 806722 589583 417278 444880 470415 497843 495117 496462 574185 659349 688146 714211 720066 680030 603817 596950 775754 800242 804682 809195 785255 790464 804432 762163 773545 745243 730144 749669 770348 395784 501597 505462 707196 608512 678732 101773 523212 550505 695140 727554 464048 430542 522112 505946 528744 568932 546588 572719 650053 694585 678724 712073 554850 625544 640432 597670 599401 613335 598566 600941 608669 615627 625134 591195 591832 604813 641485 783670 733672 629821 427336 489195 495293 394566 393921 388341 441097 414932 456156 515340 697013 714833 665600 694935 617339 784747 785967 786662 791186 792420 791441 810811 754078 760227 801715 736785 775632 779720 782079 790568 791394 802059 ] |
||||||||||||||||||||||||||||||
|
4.10 ms (2.62%) |
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 101773 388341 393921 394566 395784 414932 417278 427336 430542 441097 444880 456156 462538 464048 466899 470415 489195 495117 495293 496462 497843 501597 505462 505946 515340 522112 523212 523347 528744 542915 546588 550505 554850 556790 564625 568932 572719 574185 589583 591195 591832 596950 597670 598566 599401 600941 603817 604813 608512 608669 613335 615627 615686 617339 625134 625544 629821 640432 641485 650053 659349 665600 678724 678732 680030 688146 694585 694935 695140 697013 707196 712073 714211 714833 720066 727554 730144 733672 735974 736785 745243 749669 754078 757318 760227 762163 764077 767793 770348 773545 773813 775632 775754 779720 781584 782079 783670 784747 785255 785468 785967 786662 790084 790464 790568 791186 791394 791441 792420 794398 800242 801715 802059 804432 804682 806722 809195 810811 811785 817417 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur fucking pussy"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск fucking pussy"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск fucking 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.