Query Metrics
7
Database Queries
7
Different statements
144.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.38 ms (83.37%) |
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 55266 170836 334847 382057 383063 383912 386449 392785 392787 393081 395142 413136 416408 422295 422484 428468 429504 430486 437361 437582 438199 442415 442418 443969 448965 450161 450181 451271 451711 452616 454029 455273 460555 460679 469370 477067 480833 482629 492115 493201 506136 512895 513118 515317 519821 519856 521796 523184 524783 525551 528826 529663 531935 531979 532054 532110 532111 532131 538329 543773 546425 548489 549644 561597 562952 564378 565626 565898 569394 578348 591049 591258 592933 599716 605261 609823 610114 630630 639225 661944 669704 676591 682181 687942 689002 695128 713652 716535 719977 724502 730550 736379 743362 746497 753764 755695 758564 759088 768208 769490 774316 775129 775271 777217 777270 777729 779576 795360 801493 802075 803518 808859 813913 813918 823619 ] |
||||||||||||||||||||||||||||||
|
13.91 ms (9.63%) |
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 609823 743362 768208 531935 392785 808859 777270 713652 801493 519856 716535 777729 529663 599716 428468 605261 532111 823619 460555 661944 429504 695128 492115 532054 802075 687942 719977 578348 669704 548489 730550 477067 775129 610114 538329 532110 413136 515317 170836 443969 724502 546425 769530 519821 795360 438199 775271 469370 524783 510295 630630 736379 777217 803518 448965 531979 395142 521796 565898 450181 512895 437361 689002 528826 525551 591049 591258 769490 697939 543773 549644 676582 532131 392787 639225 451271 482629 759088 382057 676591 455273 452616 383912 813918 755695 383063 513118 758564 592933 55266 422484 416408 493201 523184 430486 561597 562952 451711 334847 480833 454029 813913 442418 460679 779576 393081 682181 564378 386449 569394 437582 746497 697943 442415 506136 774316 753764 422295 450161 565626 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (2.01%) |
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 55266 170836 334847 382057 383063 383912 386449 392785 392787 393081 395142 413136 416408 422295 422484 428468 429504 430486 437361 437582 438199 442415 442418 443969 448965 450161 450181 451271 451711 452616 454029 455273 460555 460679 469370 477067 480833 482629 492115 493201 506136 512895 513118 515317 519821 519856 521796 523184 524783 525551 528826 529663 531935 531979 532054 532110 532111 532131 538329 543773 546425 548489 549644 561597 562952 564378 565626 565898 569394 578348 591049 591258 592933 599716 605261 609823 610114 630630 639225 661944 669704 676591 682181 687942 689002 695128 713652 716535 719977 724502 730550 736379 743362 746497 753764 755695 758564 759088 768208 769490 774316 775129 775271 777217 777270 777729 779576 795360 801493 802075 803518 808859 813913 813918 823619 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom handjob son"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom дрочк член son"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom дрочк член son"
]
|
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.