Query Metrics
7
Database Queries
7
Different statements
175.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.22 ms (82.80%) |
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 398949 401456 402792 403641 405222 410272 413641 423973 424682 426030 426323 428458 428970 433038 433966 436690 437605 439579 440682 447009 458518 466950 470207 475089 478511 479016 480832 480959 481847 481935 483715 485192 486779 487342 487750 488559 490219 490370 495670 498057 500302 501474 501623 503213 505819 506597 506816 510876 511141 514828 514832 515107 516121 518102 518368 520015 520485 521905 522895 522913 526730 527941 529143 529412 550985 551642 554298 566180 567051 567152 569332 571762 572297 577392 583238 583386 585253 585400 585951 589152 590863 594213 596550 605371 606763 607132 610786 610931 612868 631170 639972 641370 643100 653596 663856 665466 667288 670820 693077 704914 707306 714530 720718 751991 762213 762217 763540 773833 789702 789840 795683 805554 808044 808176 811738 814511 814553 814733 815735 816949 ] |
||||||||||||||||||||||||||||||
|
19.97 ms (11.38%) |
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 481935 466950 667288 805554 789702 808176 480832 480959 488559 505819 436690 500302 503213 485192 704914 610931 773833 475089 437605 440682 506597 483715 521905 495670 401456 526730 403641 720718 470207 490370 433038 490219 707306 639972 594213 426030 511141 402792 814511 814553 551642 583386 714530 670820 693077 585253 589152 590863 605371 789840 763540 808044 751991 413641 518102 653596 554298 607132 811738 423973 398949 478511 520485 583238 569332 426323 433966 518368 501623 428970 501474 486779 520015 527941 571762 663856 665466 585400 606763 487342 816949 510876 550985 566180 572297 596550 643100 795683 762213 428458 814733 815735 631170 641370 439579 405222 506816 487750 514828 762217 481847 529412 522895 458518 447009 529143 498057 567051 522913 567152 577392 410272 514832 479016 612868 424682 516121 515107 585951 610786 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.77%) |
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 398949 401456 402792 403641 405222 410272 413641 423973 424682 426030 426323 428458 428970 433038 433966 436690 437605 439579 440682 447009 458518 466950 470207 475089 478511 479016 480832 480959 481847 481935 483715 485192 486779 487342 487750 488559 490219 490370 495670 498057 500302 501474 501623 503213 505819 506597 506816 510876 511141 514828 514832 515107 516121 518102 518368 520015 520485 521905 522895 522913 526730 527941 529143 529412 550985 551642 554298 566180 567051 567152 569332 571762 572297 577392 583238 583386 585253 585400 585951 589152 590863 594213 596550 605371 606763 607132 610786 610931 612868 631170 639972 641370 643100 653596 663856 665466 667288 670820 693077 704914 707306 714530 720718 751991 762213 762217 763540 773833 789702 789840 795683 805554 808044 808176 811738 814511 814553 814733 815735 816949 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big both"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие both"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие both"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.93%) |
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.