Query Metrics
7
Database Queries
7
Different statements
165.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.20 ms (81.16%) |
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 97401 389114 393692 395249 396214 410524 410623 417121 417839 419272 420860 422409 425686 430142 433282 437118 437708 437966 437980 442664 443904 445651 447507 449141 449531 452264 452923 452974 457869 457904 457972 458783 468426 468689 469619 479754 483574 490529 492288 494158 495142 498600 502636 503032 507795 508962 510006 511400 517843 517973 518049 519562 520829 524255 524939 534816 535531 539233 541706 558592 559045 561313 561701 561893 564390 567503 582029 583593 586876 590123 590778 591726 591747 593649 594282 594353 595465 597527 600433 609343 618586 624755 626117 633607 639873 641830 645322 651957 664497 673003 684383 684465 684511 691450 712509 717898 717966 719266 721381 722512 723277 723911 724139 740965 742854 748046 755030 761540 762902 765743 772664 773701 775239 787506 795403 795431 806324 806931 826248 ] |
||||||||||||||||||||||||||||||
|
19.72 ms (11.92%) |
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 420860 437966 442664 826248 452974 457904 458783 503032 510006 524255 564390 582029 645322 717898 684383 723277 590123 609343 641830 639873 590778 618586 806931 795403 723911 762902 773701 717966 469619 433282 452264 534816 483574 524939 498600 410623 417121 457869 494158 519562 535531 495142 558592 559045 561313 712509 673003 674534 586876 626117 591726 633607 775239 748046 761540 724139 447507 393692 449141 425686 449531 502636 541706 507795 517973 567503 395249 437980 468426 561701 651957 684511 691450 719266 594282 595465 591747 597527 795431 742854 765743 740965 772664 721381 787506 389114 396214 437708 806324 457972 518049 583593 593649 600433 755030 594353 410524 508962 664497 624755 722512 417839 511400 479754 452923 422409 517843 561893 97401 419272 443904 437118 430142 684465 490529 492288 445651 468689 520829 539233 ] |
||||||||||||||||||||||||||||||
|
3.53 ms (2.13%) |
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 97401 389114 393692 395249 396214 410524 410623 417121 417839 419272 420860 422409 425686 430142 433282 437118 437708 437966 437980 442664 443904 445651 447507 449141 449531 452264 452923 452974 457869 457904 457972 458783 468426 468689 469619 479754 483574 490529 492288 494158 495142 498600 502636 503032 507795 508962 510006 511400 517843 517973 518049 519562 520829 524255 524939 534816 535531 539233 541706 558592 559045 561313 561701 561893 564390 567503 582029 583593 586876 590123 590778 591726 591747 593649 594282 594353 595465 597527 600433 609343 618586 624755 626117 633607 639873 641830 645322 651957 664497 673003 684383 684465 684511 691450 712509 717898 717966 719266 721381 722512 723277 723911 724139 740965 742854 748046 755030 761540 762902 765743 772664 773701 775239 787506 795403 795431 806324 806931 826248 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tight teen ass"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"tight teen жоп"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"tight teen жоп"
]
|
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.