Query Metrics
7
Database Queries
7
Different statements
182.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.14 ms (85.49%) |
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 70659 192951 386883 390089 390175 395705 395839 396276 399691 400100 400126 403240 404831 409200 409878 412910 415404 416936 419575 427929 442095 461011 464212 478413 481637 481669 484802 497214 515632 530886 565022 566901 582793 589200 589324 590907 604549 612038 615538 617185 629362 629744 632044 639974 675220 675305 675923 675954 675968 675971 675986 675995 676279 679462 683404 696047 702446 703207 711337 712047 712466 712655 718302 723102 725335 729233 746100 752566 763313 766715 769502 770524 770670 770833 770883 770986 771841 772970 774297 776307 777064 779194 784257 786153 789042 793427 795525 797879 798429 805374 805876 809241 810945 810967 811461 815316 815379 815988 817320 817935 818221 818282 818474 820336 820346 820353 820394 820747 821201 821220 821598 821610 822272 822497 822645 822832 822960 823411 823491 827262 ] |
||||||||||||||||||||||||||||||
|
15.26 ms (8.35%) |
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 770986 497214 419575 416936 683404 589324 798429 809241 442095 478413 515632 481637 70659 192951 400126 769502 582793 427929 565022 404831 818221 815379 818474 820336 712047 675305 617185 712655 793427 815316 590907 725335 770670 772970 702446 390175 390089 822960 822645 823411 675220 566901 711337 604549 629744 395839 399691 386883 795525 805876 396276 464212 821201 820747 817320 675986 615538 632044 789042 770524 752566 746100 763313 612038 776307 400100 403240 821598 821220 820394 822832 815988 679462 675923 696047 589200 777064 786153 805374 770833 770883 729233 629362 703207 409200 481669 675954 820353 817935 818282 823491 712466 675968 723102 675971 639974 766715 771841 774297 784257 412910 415404 395705 821610 827262 822497 822272 530886 718302 676279 810967 797879 810945 811461 409878 820346 675995 779194 461011 484802 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (1.86%) |
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 70659 192951 386883 390089 390175 395705 395839 396276 399691 400100 400126 403240 404831 409200 409878 412910 415404 416936 419575 427929 442095 461011 464212 478413 481637 481669 484802 497214 515632 530886 565022 566901 582793 589200 589324 590907 604549 612038 615538 617185 629362 629744 632044 639974 675220 675305 675923 675954 675968 675971 675986 675995 676279 679462 683404 696047 702446 703207 711337 712047 712466 712655 718302 723102 725335 729233 746100 752566 763313 766715 769502 770524 770670 770833 770883 770986 771841 772970 774297 776307 777064 779194 784257 786153 789042 793427 795525 797879 798429 805374 805876 809241 810945 810967 811461 815316 815379 815988 817320 817935 818221 818282 818474 820336 820346 820353 820394 820747 821201 821220 821598 821610 822272 822497 822645 822832 822960 823411 823491 827262 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс латинская"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex latina"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.86%) |
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.