Query Metrics
7
Database Queries
7
Different statements
192.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.50 ms (85.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 233042 388707 411161 418077 419352 420674 424015 424624 428835 429706 429957 432211 435355 437190 438100 439027 439584 443715 443919 444189 444618 445019 446302 448553 452548 455127 465144 466394 471969 472421 476049 477129 484199 487548 489804 490387 491105 492987 495467 496690 496776 498158 498641 500825 509573 513537 516572 518822 520567 524124 528144 528935 534413 541771 543726 546011 546361 547796 550938 558123 563598 564641 571350 571792 574019 582198 590479 597085 598549 599347 614385 626019 650064 661539 666410 667942 668683 671516 679190 680578 684749 686383 691812 692831 703946 721595 722292 723909 725512 736856 740901 741737 742104 751637 754653 754804 758277 761974 763465 765808 766381 766412 767496 774653 779587 782152 783176 783335 784213 785473 788045 791179 791329 802231 803404 805142 810398 810749 812663 828033 ] |
||||||||||||||||||||||||||||||
|
17.21 ms (8.96%) |
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 489804 492987 498158 520567 496776 500825 516572 541771 684749 680578 686383 722292 661539 668683 671516 691812 692831 599347 614385 802231 803404 812663 740901 742104 782152 783176 783335 725512 751637 763465 765808 754653 767496 754804 758277 703946 785473 805142 810398 424015 411161 496690 574019 666410 788045 388707 429706 439027 490387 534413 582198 564641 571792 419352 444618 452548 465144 472421 418077 420674 432211 437190 455127 471969 424624 476049 528935 495467 498641 509573 513537 487548 518822 528144 429957 477129 543726 558123 650064 679190 721595 546011 550938 563598 597085 626019 598549 774653 791179 741737 791329 736856 761974 766381 723909 233042 428835 443715 443919 491105 546361 571350 547796 667942 590479 448553 435355 445019 439584 444189 438100 446302 466394 524124 484199 828033 810749 766412 784213 779587 ] |
||||||||||||||||||||||||||||||
|
4.21 ms (2.19%) |
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 233042 388707 411161 418077 419352 420674 424015 424624 428835 429706 429957 432211 435355 437190 438100 439027 439584 443715 443919 444189 444618 445019 446302 448553 452548 455127 465144 466394 471969 472421 476049 477129 484199 487548 489804 490387 491105 492987 495467 496690 496776 498158 498641 500825 509573 513537 516572 518822 520567 524124 528144 528935 534413 541771 543726 546011 546361 547796 550938 558123 563598 564641 571350 571792 574019 582198 590479 597085 598549 599347 614385 626019 650064 661539 666410 667942 668683 671516 679190 680578 684749 686383 691812 692831 703946 721595 722292 723909 725512 736856 740901 741737 742104 751637 754653 754804 758277 761974 763465 765808 766381 766412 767496 774653 779587 782152 783176 783335 784213 785473 788045 791179 791329 802231 803404 805142 810398 810749 812663 828033 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.