Query Metrics
7
Database Queries
7
Different statements
181.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.59 ms (85.70%) |
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 76043 80663 96665 123769 154826 188552 191485 322284 383700 383980 384027 384275 386276 387742 388740 389788 392904 395735 400480 400497 406405 412827 413690 414763 417015 419170 420513 421819 421830 421843 421871 422172 426673 427326 427486 428033 428039 439723 444298 444679 448650 452547 452654 453750 453799 454105 455309 455539 456603 457804 463376 467935 470474 474122 474268 478320 478362 478372 479533 479987 481105 483567 492222 493963 507693 511205 511616 513557 516480 516737 517069 518762 519008 524499 529986 532999 535433 536275 551461 552285 555400 556519 560903 561852 564942 565321 565817 567502 574896 579875 581579 589045 593821 601698 618948 619582 625342 633980 642371 642401 661263 668972 671584 685390 685402 685425 705291 721322 728152 754470 758355 765218 776527 787486 794373 800420 800528 800537 815740 827994 ] |
||||||||||||||||||||||||||||||
|
15.85 ms (8.73%) |
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 493963 456603 705291 444298 535433 470474 439723 593821 478372 794373 532999 444679 567502 421871 685402 455309 721322 625342 642401 800528 400497 800420 765218 479533 668972 787486 383980 322284 728152 685390 389788 601698 565817 800537 384027 427486 511205 479987 76043 754470 518762 426673 428039 618948 395735 529986 457804 581579 452654 463376 552285 383700 758355 412827 642371 421830 96665 80663 455539 513557 428033 386276 419170 406405 492222 815740 474268 392904 564942 776527 454105 427326 524499 474122 619582 388740 827994 414763 579875 188552 422172 565321 574896 478320 555400 417015 551461 448650 517069 191485 453750 536275 671584 420513 421843 453799 467935 384275 516737 685425 478362 556519 560903 400480 561852 661263 421819 481105 516480 633980 589045 413690 519008 123769 154826 387742 452547 483567 507693 511616 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.72%) |
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 76043 80663 96665 123769 154826 188552 191485 322284 383700 383980 384027 384275 386276 387742 388740 389788 392904 395735 400480 400497 406405 412827 413690 414763 417015 419170 420513 421819 421830 421843 421871 422172 426673 427326 427486 428033 428039 439723 444298 444679 448650 452547 452654 453750 453799 454105 455309 455539 456603 457804 463376 467935 470474 474122 474268 478320 478362 478372 479533 479987 481105 483567 492222 493963 507693 511205 511616 513557 516480 516737 517069 518762 519008 524499 529986 532999 535433 536275 551461 552285 555400 556519 560903 561852 564942 565321 565817 567502 574896 579875 581579 589045 593821 601698 618948 619582 625342 633980 642371 642401 661263 668972 671584 685390 685402 685425 705291 721322 728152 754470 758355 765218 776527 787486 794373 800420 800528 800537 815740 827994 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"kitchen sex anal"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кухн секс анал"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кухн секс анал"
]
|
||||||||||||||||||||||||||||||
|
1.68 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.