Query Metrics
8
Database Queries
8
Different statements
192.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.07 ms (81.76%) |
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 39719 66540 383447 384541 385420 393728 393779 395609 400137 401985 404059 404950 417920 418290 420548 422576 422584 422656 422881 423283 429097 433694 445933 449019 451554 453602 454861 455016 462517 463766 466395 466916 467344 470324 470359 470847 472439 475122 477348 479219 481719 486277 491487 494426 506665 506811 518316 519986 521357 525648 534126 534713 543547 547687 551340 552151 552617 556320 558135 558191 559009 562886 564443 564808 566618 567003 567147 567152 567761 569427 569672 571280 571958 574529 575123 575737 576021 576051 580197 580237 581184 581401 591520 591600 604069 611922 612799 621436 630852 651893 654619 655718 655752 657025 657030 657309 658296 659117 659161 659622 662481 665221 667242 667323 676942 703510 720766 721551 726603 735985 741445 748667 748670 774160 775621 789212 795515 805194 807501 814148 ] |
||||||||||||||||||||||||||||||
|
19.49 ms (10.14%) |
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 659161 658296 720766 654619 591520 735985 703510 775621 547687 558135 576051 564443 564808 567003 552617 556320 567147 567152 575737 559009 562886 571958 575123 604069 521357 748667 611922 581401 417920 393779 429097 449019 491487 486277 534126 506811 576021 581184 543547 567761 462517 466916 475122 481719 393728 400137 455016 467344 506665 519986 494426 574529 612799 383447 659117 748670 66540 385420 558191 525648 774160 39719 814148 477348 534713 571280 651893 667323 676942 621436 789212 795515 726603 453602 420548 454861 518316 551340 552151 566618 657030 659622 662481 657025 665221 667242 655718 655752 657309 630852 805194 741445 807501 384541 479219 401985 433694 422656 422576 422584 423283 445933 470359 451554 569427 580197 580237 721551 569672 591600 404059 463766 418290 404950 395609 422881 466395 470324 470847 472439 ] |
||||||||||||||||||||||||||||||
|
5.09 ms (2.65%) |
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 39719 66540 383447 384541 385420 393728 393779 395609 400137 401985 404059 404950 417920 418290 420548 422576 422584 422656 422881 423283 429097 433694 445933 449019 451554 453602 454861 455016 462517 463766 466395 466916 467344 470324 470359 470847 472439 475122 477348 479219 481719 486277 491487 494426 506665 506811 518316 519986 521357 525648 534126 534713 543547 547687 551340 552151 552617 556320 558135 558191 559009 562886 564443 564808 566618 567003 567147 567152 567761 569427 569672 571280 571958 574529 575123 575737 576021 576051 580197 580237 581184 581401 591520 591600 604069 611922 612799 621436 630852 651893 654619 655718 655752 657025 657030 657309 658296 659117 659161 659622 662481 665221 667242 667323 676942 703510 720766 721551 726603 735985 741445 748667 748670 774160 775621 789212 795515 805194 807501 814148 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая мужчин"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small man"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая мужчин"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.09%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01ö\x08\x07V(r-å{ØLrîÚÓ"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.