Query Metrics
7
Database Queries
7
Different statements
151.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.95 ms (81.21%) |
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 95943 391562 391911 391986 393742 400719 401932 405112 423010 426459 427097 427170 434289 438045 444238 450641 453601 455767 456955 461948 462194 462553 463096 475102 476230 476244 476598 477389 477994 478847 479114 484130 484364 484383 484542 485374 485711 487764 489015 491119 492625 492660 493033 496288 507017 509024 518852 519676 519895 524969 525485 525529 526546 527048 541632 541636 542960 546954 548228 548229 548233 549335 549406 551909 551916 551921 554639 556029 559121 559123 559124 561061 562836 564470 571201 576653 576698 576720 576722 578445 584709 584711 584713 584714 610607 619082 619399 621712 622373 622381 659369 670951 671746 702300 705334 716968 731297 734791 736250 737240 738172 739097 739717 740673 740768 740966 742974 747140 748108 749853 753238 763399 771514 790318 810373 810378 810941 813680 813707 828398 ] |
||||||||||||||||||||||||||||||
|
17.65 ms (11.66%) |
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 476230 584711 576698 548233 619082 427170 462553 813707 813680 828398 753238 496288 519895 576722 551909 475102 405112 461948 393742 509024 549335 559123 610607 401932 525529 493033 485374 487764 525485 551921 450641 476598 477994 492660 731297 763399 391911 462194 507017 489015 549406 479114 434289 478847 519676 810941 391986 527048 748108 739097 740673 740768 716968 546954 619399 622373 659369 702300 742974 749853 584714 476244 526546 548228 747140 95943 426459 559124 554639 576653 541632 578445 548229 559121 551916 621712 438045 564470 810378 456955 427097 453601 423010 463096 541636 622381 391562 737240 771514 477389 736250 734791 562836 556029 524969 739717 790318 485711 484542 492625 455767 584713 400719 491119 542960 671746 584709 484383 444238 810373 484364 740966 738172 518852 705334 561061 484130 571201 576720 670951 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.94%) |
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 95943 391562 391911 391986 393742 400719 401932 405112 423010 426459 427097 427170 434289 438045 444238 450641 453601 455767 456955 461948 462194 462553 463096 475102 476230 476244 476598 477389 477994 478847 479114 484130 484364 484383 484542 485374 485711 487764 489015 491119 492625 492660 493033 496288 507017 509024 518852 519676 519895 524969 525485 525529 526546 527048 541632 541636 542960 546954 548228 548229 548233 549335 549406 551909 551916 551921 554639 556029 559121 559123 559124 561061 562836 564470 571201 576653 576698 576720 576722 578445 584709 584711 584713 584714 610607 619082 619399 621712 622373 622381 659369 670951 671746 702300 705334 716968 731297 734791 736250 737240 738172 739097 739717 740673 740768 740966 742974 747140 748108 749853 753238 763399 771514 790318 810373 810378 810941 813680 813707 828398 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"village sex"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"деревня секс"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.16%) |
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.