Query Metrics
7
Database Queries
7
Different statements
154.82 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.77 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.11 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf-mom-anal"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.72 ms |
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 817832 815456 817278 818327 817747 815541 826521 550373 583538 694135 640677 600314 811503 779116 800052 743066 785915 787274 787479 795540 765515 770911 751571 752121 604435 641946 775436 359420 397921 393108 395724 399632 425657 418778 466679 552285 561002 582479 541568 649559 670356 547471 578074 593207 807352 751773 409316 466690 401333 421883 395861 457804 477110 421155 642743 567405 672383 464210 512770 593604 625686 398811 815283 815391 815931 816529 723652 815480 816545 817341 817786 820586 823593 815078 815140 815165 815542 815751 815876 815955 819508 822930 824500 815142 815418 816319 818468 502788 671758 695988 718746 721163 664486 694479 681075 690091 694441 596899 600083 605157 634500 640321 638543 786195 786527 798643 805908 781326 807394 736412 801261 802870 805935 737554 756254 756426 760806 766381 726265 742321 ] |
||||||||||||||||||||||||||||||
| 4 | 2.32 ms |
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 359420 393108 395724 395861 397921 398811 399632 401333 409316 418778 421155 421883 425657 457804 464210 466679 466690 477110 502788 512770 541568 547471 550373 552285 561002 567405 578074 582479 583538 593207 593604 596899 600083 600314 604435 605157 625686 634500 638543 640321 640677 641946 642743 649559 664486 670356 671758 672383 681075 690091 694135 694441 694479 695988 718746 721163 723652 726265 736412 737554 742321 743066 751571 751773 752121 756254 756426 760806 765515 766381 770911 775436 779116 781326 785915 786195 786527 787274 787479 795540 798643 800052 801261 802870 805908 805935 807352 807394 811503 815078 815140 815142 815165 815283 815391 815418 815456 815480 815541 815542 815751 815876 815931 815955 816319 816529 816545 817278 817341 817747 817786 817832 818327 818468 819508 820586 822930 823593 824500 826521 ] |
||||||||||||||||||||||||||||||
| 5 | 129.91 ms |
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 359420 393108 395724 395861 397921 398811 399632 401333 409316 418778 421155 421883 425657 457804 464210 466679 466690 477110 502788 512770 541568 547471 550373 552285 561002 567405 578074 582479 583538 593207 593604 596899 600083 600314 604435 605157 625686 634500 638543 640321 640677 641946 642743 649559 664486 670356 671758 672383 681075 690091 694135 694441 694479 695988 718746 721163 723652 726265 736412 737554 742321 743066 751571 751773 752121 756254 756426 760806 765515 766381 770911 775436 779116 781326 785915 786195 786527 787274 787479 795540 798643 800052 801261 802870 805908 805935 807352 807394 811503 815078 815140 815142 815165 815283 815391 815418 815456 815480 815541 815542 815751 815876 815931 815955 816319 816529 816545 817278 817341 817747 817786 817832 818327 818468 819508 820586 822930 823593 824500 826521 ] |
||||||||||||||||||||||||||||||
| 6 | 2.12 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf mom анал"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.88 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf mom анал"
]
|
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.