Query Metrics
7
Database Queries
7
Different statements
182.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.47 ms (85.70%) |
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 72589 397912 409931 426475 445943 446274 453137 468337 468434 469551 476168 478420 478421 490952 492658 493743 493757 497509 499617 505387 506257 507542 511500 513672 514854 516140 517272 529658 529795 529799 530451 531121 531250 531757 531824 531840 531861 534562 536299 537476 538810 541277 546836 547809 549836 551468 552286 552544 555074 555209 555258 555329 555359 555363 555389 559202 559355 560400 563171 563548 564301 564388 565275 571961 576605 576919 589610 613482 614192 619614 630828 646664 665802 669046 669057 670372 708813 710100 713503 714986 715879 720631 722058 722376 723659 727573 728152 729228 730069 732253 734968 735017 743934 749234 756428 761061 761347 762301 765915 767196 768870 770149 770304 775693 782789 785549 788549 790368 791783 796314 798999 799683 805099 805524 805736 805784 818634 825038 825557 826267 ] |
||||||||||||||||||||||||||||||
|
17.98 ms (9.85%) |
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 762301 536299 576919 791783 564301 552286 476168 805736 547809 555389 559355 478420 469551 445943 825038 531824 546836 665802 630828 796314 805099 805784 727573 768870 708813 529795 531250 529799 531121 505387 511500 555363 564388 555209 555329 670372 669057 549836 552544 555258 565275 613482 749234 770149 492658 516140 493743 513672 517272 723659 529658 531757 506257 537476 775693 798999 729228 72589 826267 426475 468337 514854 490952 560400 563548 619614 732253 446274 468434 493757 497509 782789 499617 507542 563171 541277 576605 756428 538810 646664 409931 825557 743934 551468 555074 788549 453137 559202 735017 799683 555359 614192 805524 761347 397912 720631 478421 530451 534562 531840 531861 571961 710100 713503 715879 765915 767196 728152 730069 734968 761061 770304 714986 722058 722376 785549 790368 589610 669046 818634 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.33%) |
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 72589 397912 409931 426475 445943 446274 453137 468337 468434 469551 476168 478420 478421 490952 492658 493743 493757 497509 499617 505387 506257 507542 511500 513672 514854 516140 517272 529658 529795 529799 530451 531121 531250 531757 531824 531840 531861 534562 536299 537476 538810 541277 546836 547809 549836 551468 552286 552544 555074 555209 555258 555329 555359 555363 555389 559202 559355 560400 563171 563548 564301 564388 565275 571961 576605 576919 589610 613482 614192 619614 630828 646664 665802 669046 669057 670372 708813 710100 713503 714986 715879 720631 722058 722376 723659 727573 728152 729228 730069 732253 734968 735017 743934 749234 756428 761061 761347 762301 765915 767196 768870 770149 770304 775693 782789 785549 788549 790368 791783 796314 798999 799683 805099 805524 805736 805784 818634 825038 825557 826267 ] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal mature gape"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал mature большая большие дырк"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал mature большая большие дырк"
]
|
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.