Query Metrics
7
Database Queries
7
Different statements
166.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.63 ms (85.92%) |
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 540059 540135 540136 540326 541166 542397 542498 542719 544229 544234 545424 547409 547566 552604 553674 553695 554191 554714 554717 554723 555261 555406 555421 555773 558624 561025 561049 562036 562493 564205 567515 574452 575026 575326 575847 576580 577188 580984 582505 583057 583536 593028 596606 596972 599902 603414 605179 607312 607676 621710 621713 627233 628387 628535 628668 629315 629820 630105 630468 631439 631898 632887 634145 634810 637080 637163 639626 640239 640856 641561 641985 646081 650127 664562 665326 666045 666579 667450 668526 670272 670794 671782 672324 672765 676112 677293 678135 679577 680112 680118 680172 680204 680493 680778 695835 696996 700919 707495 720598 724317 752616 766348 771623 775212 788888 793466 797224 797230 801406 801825 803691 803700 804417 806268 812225 812248 814318 825968 826491 827401 ] |
||||||||||||||||||||||||||||||
|
14.11 ms (8.50%) |
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 555421 575326 575847 547566 575026 670794 680493 680778 700919 671782 621710 629820 631898 596606 628668 788888 752616 797224 603414 630468 641561 804417 561049 541166 607312 640239 797230 680112 696996 677293 545424 564205 634145 599902 825968 827401 628535 540059 540135 580984 583536 542498 554191 554723 561025 544234 553674 577188 583057 707495 646081 664562 666579 672765 680204 552604 632887 596972 775212 801825 803700 803691 771623 724317 634810 801406 540136 666045 665326 640856 812248 814318 544229 554714 576580 567515 542397 542719 547409 555773 562036 695835 672324 680172 670272 679577 554717 558624 574452 607676 629315 639626 641985 621713 627233 637163 605179 630105 766348 806268 720598 793466 668526 676112 650127 678135 680118 628387 637080 540326 826491 562493 553695 667450 555261 555406 582505 593028 631439 812225 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.66%) |
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 540059 540135 540136 540326 541166 542397 542498 542719 544229 544234 545424 547409 547566 552604 553674 553695 554191 554714 554717 554723 555261 555406 555421 555773 558624 561025 561049 562036 562493 564205 567515 574452 575026 575326 575847 576580 577188 580984 582505 583057 583536 593028 596606 596972 599902 603414 605179 607312 607676 621710 621713 627233 628387 628535 628668 629315 629820 630105 630468 631439 631898 632887 634145 634810 637080 637163 639626 640239 640856 641561 641985 646081 650127 664562 665326 666045 666579 667450 668526 670272 670794 671782 672324 672765 676112 677293 678135 679577 680112 680118 680172 680204 680493 680778 695835 696996 700919 707495 720598 724317 752616 766348 771623 775212 788888 793466 797224 797230 801406 801825 803691 803700 804417 806268 812225 812248 814318 825968 826491 827401 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"piss and"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"писсинг"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"писсинг"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.83%) |
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.