Query Metrics
7
Database Queries
7
Different statements
190.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.54 ms (88.64%) |
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 389842 400823 415344 419998 424099 429706 443135 443950 444236 446787 449377 451517 454133 455297 457358 459636 460582 463255 465393 465428 470107 470690 475877 477420 482947 485945 486820 490514 491310 494566 495260 495498 500378 505287 506713 509019 518616 520609 529999 533754 533781 535613 537263 537983 539366 541032 543541 543670 546655 554747 558686 559467 560005 571792 579209 579587 580242 590240 590410 600142 601986 603834 616682 616771 662147 666518 671858 671883 682758 700476 701733 702283 704673 705111 709511 711716 711777 721575 721597 724770 726398 727523 730826 731197 731659 732725 736128 736275 742405 744177 749766 758231 760382 760517 760520 762274 763859 764112 764121 768163 768472 768486 782366 787286 791412 793930 794845 795207 795329 797348 797355 802160 803479 809561 810315 813628 819269 823647 823738 824094 ] |
||||||||||||||||||||||||||||||
|
12.12 ms (6.37%) |
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 443135 736275 793930 546655 537983 543670 702283 711716 616771 600142 616682 760520 768163 731197 760382 731659 470107 465428 762274 823647 819269 782366 554747 505287 494566 490514 429706 813628 802160 797348 803479 794845 795207 732725 763859 791412 797355 810315 518616 500378 444236 539366 463255 559467 470690 495260 482947 475877 419998 459636 506713 491310 495498 730826 742405 443950 400823 449377 460582 486820 558686 579587 579209 758231 389842 477420 457358 454133 509019 537263 701733 424099 451517 666518 671858 671883 535613 721597 721575 787286 736128 760517 764121 809561 749766 768486 726398 727523 764112 768472 795329 465393 415344 485945 455297 529999 580242 571792 590410 446787 662147 704673 705111 560005 603834 601986 700476 709511 533754 533781 520609 543541 541032 682758 590240 724770 744177 823738 824094 711777 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.48%) |
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 389842 400823 415344 419998 424099 429706 443135 443950 444236 446787 449377 451517 454133 455297 457358 459636 460582 463255 465393 465428 470107 470690 475877 477420 482947 485945 486820 490514 491310 494566 495260 495498 500378 505287 506713 509019 518616 520609 529999 533754 533781 535613 537263 537983 539366 541032 543541 543670 546655 554747 558686 559467 560005 571792 579209 579587 580242 590240 590410 600142 601986 603834 616682 616771 662147 666518 671858 671883 682758 700476 701733 702283 704673 705111 709511 711716 711777 721575 721597 724770 726398 727523 730826 731197 731659 732725 736128 736275 742405 744177 749766 758231 760382 760517 760520 762274 763859 764112 764121 768163 768472 768486 782366 787286 791412 793930 794845 795207 795329 797348 797355 802160 803479 809561 810315 813628 819269 823647 823738 824094 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian milf homemade"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск milf домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск milf домашн любительск"
]
|
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.