Query Metrics
7
Database Queries
7
Different statements
163.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.76 ms (85.30%) |
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 405705 415148 423749 428726 431372 432120 437649 441698 442857 443841 451225 451241 453482 453900 453978 454609 455039 455390 455451 456573 458495 459504 459727 463501 464660 466755 468805 469678 472284 472414 472751 473168 473846 478480 478705 479217 480933 486278 488628 489663 491518 492839 501543 504050 504112 504197 506769 508076 509667 511927 512629 513769 517702 517986 521056 523364 524914 527039 538021 543506 545190 546806 548704 549479 553833 555782 560038 568750 568819 575704 575827 576324 576849 578207 581213 583240 585703 586478 586695 588962 592009 595477 596479 596642 598084 598519 598721 598871 602633 604357 605986 608471 610346 613028 619092 621778 625673 626072 626321 628185 630115 636554 641375 652213 662454 677358 677361 680395 705875 706599 736564 736881 741294 745648 758024 764869 776126 790888 811606 813184 ] |
||||||||||||||||||||||||||||||
|
15.22 ms (9.29%) |
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 451225 453978 478705 488628 504112 511927 513769 521056 463501 486278 548704 575827 543506 545190 555782 568819 578207 581213 546806 549479 560038 568750 677358 662454 706599 677361 680395 705875 595477 613028 619092 628185 596479 598084 602633 621778 610346 588962 592009 626072 776126 813184 745648 764869 758024 736881 626321 405705 441698 453482 451241 442857 480933 437649 478480 455390 458495 459504 504197 509667 489663 491518 501543 504050 517986 630115 432120 415148 428726 443841 453900 468805 479217 492839 472284 473846 512629 523364 538021 506769 517702 524914 527039 472414 576324 575704 576849 652213 553833 583240 605986 585703 586478 598721 608471 641375 586695 596642 598519 598871 790888 811606 736564 741294 604357 625673 636554 455451 464660 472751 423749 454609 456573 466755 455039 459727 469678 473168 431372 508076 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.57%) |
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 405705 415148 423749 428726 431372 432120 437649 441698 442857 443841 451225 451241 453482 453900 453978 454609 455039 455390 455451 456573 458495 459504 459727 463501 464660 466755 468805 469678 472284 472414 472751 473168 473846 478480 478705 479217 480933 486278 488628 489663 491518 492839 501543 504050 504112 504197 506769 508076 509667 511927 512629 513769 517702 517986 521056 523364 524914 527039 538021 543506 545190 546806 548704 549479 553833 555782 560038 568750 568819 575704 575827 576324 576849 578207 581213 583240 585703 586478 586695 588962 592009 595477 596479 596642 598084 598519 598721 598871 602633 604357 605986 608471 610346 613028 619092 621778 625673 626072 626321 628185 630115 636554 641375 652213 662454 677358 677361 680395 705875 706599 736564 736881 741294 745648 758024 764869 776126 790888 811606 813184 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"filled teens"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"filled teens"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"filled teens"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.84%) |
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.