Query Metrics
7
Database Queries
7
Different statements
367.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.87 ms (57.97%) |
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 321277 391992 392015 400621 414277 416036 416682 417621 419167 420140 420774 421838 436639 437368 437733 438100 441041 442548 450262 452800 453390 457650 460196 460351 461153 466636 470479 471074 471092 476646 476847 480844 483684 491083 496703 497691 499302 499905 499921 502797 506692 509329 511274 512442 514233 526179 526444 527217 528281 529055 531347 536464 539875 541413 542422 545028 549554 553964 555306 560679 568864 569619 576981 577038 577719 579173 580848 583666 583689 584195 584322 584362 585294 586876 587291 589507 589602 591962 598882 600948 602467 602627 605874 607560 608505 625227 641649 644498 650540 659199 663776 667045 668620 671505 680562 680816 688990 690684 714203 751410 751692 760659 772210 774876 779769 783466 784681 786005 786898 788524 791385 793022 796372 796705 796950 803520 807244 807835 810852 814418 ] |
||||||||||||||||||||||||||||||
|
128.08 ms (34.88%) |
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 321277 391992 392015 400621 414277 416036 416682 417621 419167 420140 420774 421838 436639 437368 437733 438100 441041 442548 450262 452800 453390 457650 460196 460351 461153 466636 470479 471074 471092 476646 476847 480844 483684 491083 496703 497691 499302 499905 499921 502797 506692 509329 511274 512442 514233 526179 526444 527217 528281 529055 531347 536464 539875 541413 542422 545028 549554 553964 555306 560679 568864 569619 576981 577038 577719 579173 580848 583666 583689 584195 584322 584362 585294 586876 587291 589507 589602 591962 598882 600948 602467 602627 605874 607560 608505 625227 641649 644498 650540 659199 663776 667045 668620 671505 680562 680816 688990 690684 714203 751410 751692 760659 772210 774876 779769 783466 784681 786005 786898 788524 791385 793022 796372 796705 796950 803520 807244 807835 810852 814418 ] |
||||||||||||||||||||||||||||||
|
18.58 ms (5.06%) |
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 814418 450262 460196 527217 506692 579173 568864 580848 663776 650540 668620 680562 714203 600948 602627 605874 774876 779769 796372 807835 788524 793022 796705 796950 772210 783466 751692 751410 644498 786005 786898 791385 807244 414277 437733 509329 419167 442548 471074 560679 539875 589602 591962 400621 496703 491083 688990 667045 553964 436639 577038 461153 536464 583666 526179 483684 587291 441041 476847 471092 497691 584362 659199 586876 453390 437368 499302 502797 690684 585294 438100 321277 416036 416682 470479 457650 512442 625227 810852 417621 480844 476646 499905 584322 576981 577719 555306 584195 641649 589507 760659 452800 514233 391992 529055 420774 499921 542422 784681 607560 460351 531347 598882 541413 671505 803520 420140 526444 511274 466636 583689 680816 608505 602467 392015 421838 528281 545028 549554 569619 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"на самотыке"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (0.56%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на дилд"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.