Query Metrics
7
Database Queries
7
Different statements
183.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.82 ms (86.35%) |
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 390360 416692 420178 421325 423376 425588 426444 427530 429563 440654 460079 464614 467957 468946 473429 473447 480645 498620 540925 540926 544937 548046 548265 548565 548584 548721 548780 549261 549354 549422 549814 550097 550435 551219 551277 551640 554250 555996 556022 556082 557938 558765 559822 560230 560515 560986 561304 562253 562256 562820 563880 564808 564822 565556 565558 565564 566577 566620 567156 567773 567780 569456 570050 570067 570954 571510 573212 573718 574079 574580 574836 575787 576019 576062 577323 577914 578257 581001 581412 581692 585096 585161 586603 586623 588674 590859 590885 592444 593211 593514 593921 597193 598029 598146 598524 598657 598675 598806 599694 600494 600982 601094 601686 602653 603523 603909 604451 604541 605151 621112 644836 661253 ] |
||||||||||||||||||||||||||||||
|
15.59 ms (8.47%) |
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 423376 416692 644836 468946 473447 473429 549354 562256 574079 550435 555996 560986 573718 548721 549422 571510 575787 577914 581001 569456 588674 593514 593921 600494 593211 598146 600982 540926 421325 464614 498620 554250 560515 565558 567773 548565 548780 562253 563880 565564 551640 556082 558765 564822 570954 574580 574836 548265 549261 576062 581412 598675 604451 602653 601686 586603 420178 426444 540925 390360 425588 429563 585096 467957 480645 460079 551219 559822 556022 548584 551277 581692 661253 548046 549814 565556 566620 590885 592444 603909 440654 576019 564808 566577 544937 557938 562820 585161 427530 550097 567780 570067 578257 577323 598029 586623 599694 603523 604541 570050 597193 598657 621112 598524 590859 605151 573212 567156 561304 598806 560230 601094 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.42%) |
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 390360 416692 420178 421325 423376 425588 426444 427530 429563 440654 460079 464614 467957 468946 473429 473447 480645 498620 540925 540926 544937 548046 548265 548565 548584 548721 548780 549261 549354 549422 549814 550097 550435 551219 551277 551640 554250 555996 556022 556082 557938 558765 559822 560230 560515 560986 561304 562253 562256 562820 563880 564808 564822 565556 565558 565564 566577 566620 567156 567773 567780 569456 570050 570067 570954 571510 573212 573718 574079 574580 574836 575787 576019 576062 577323 577914 578257 581001 581412 581692 585096 585161 586603 586623 588674 590859 590885 592444 593211 593514 593921 597193 598029 598146 598524 598657 598675 598806 599694 600494 600982 601094 601686 602653 603523 603909 604451 604541 605151 621112 644836 661253 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"naked butt"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"голые butt"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"голые butt"
]
|
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.