Query Metrics
7
Database Queries
7
Different statements
206.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.37 ms (86.78%) |
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 6806 107216 343227 383227 385116 388069 389789 391044 392959 393124 393558 407171 409692 419069 422500 423498 424549 426467 427142 427388 430574 433594 433697 434209 437170 441965 443749 444728 453369 453641 456363 462891 464418 466297 475969 478427 479162 479314 481259 481357 482573 483194 484097 484476 485020 486261 486975 489074 490740 490777 491365 491611 501068 501104 503843 504740 505451 505748 508857 509560 516824 516844 517418 519238 519504 521233 522177 523449 526233 527214 528930 531114 531884 532018 532536 533118 533536 534221 534928 535297 536012 537243 539788 540056 540082 540317 541597 548900 552298 555355 556970 559140 559198 560090 563876 565842 566316 584940 614566 615016 626096 637486 653520 716744 722464 722520 753696 773045 794472 794945 794995 796726 796734 797724 809172 817063 817721 817887 823655 825124 ] |
||||||||||||||||||||||||||||||
|
16.71 ms (8.08%) |
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 389789 388069 423498 424549 456363 490777 527214 536012 522177 532536 540056 533536 534221 541597 773045 393558 427142 433594 385116 466297 107216 343227 430574 462891 479162 443749 519238 501068 453369 519504 383227 817887 823655 825124 523449 528930 534928 540082 516844 532018 537243 490740 552298 560090 548900 716744 615016 794945 809172 753696 794995 453641 419069 486975 517418 556970 422500 491611 504740 653520 559198 565842 427388 505748 491365 508857 526233 484097 434209 817721 464418 484476 485020 478427 516824 535297 501104 533118 540317 479314 566316 614566 637486 626096 407171 481259 483194 509560 531114 559140 393124 392959 426467 441965 444728 409692 817063 482573 475969 481357 486261 503843 505451 521233 531884 539788 489074 584940 563876 555355 722520 722464 796734 796726 797724 794472 6806 437170 391044 433697 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.55%) |
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 6806 107216 343227 383227 385116 388069 389789 391044 392959 393124 393558 407171 409692 419069 422500 423498 424549 426467 427142 427388 430574 433594 433697 434209 437170 441965 443749 444728 453369 453641 456363 462891 464418 466297 475969 478427 479162 479314 481259 481357 482573 483194 484097 484476 485020 486261 486975 489074 490740 490777 491365 491611 501068 501104 503843 504740 505451 505748 508857 509560 516824 516844 517418 519238 519504 521233 522177 523449 526233 527214 528930 531114 531884 532018 532536 533118 533536 534221 534928 535297 536012 537243 539788 540056 540082 540317 541597 548900 552298 555355 556970 559140 559198 560090 563876 565842 566316 584940 614566 615016 626096 637486 653520 716744 722464 722520 753696 773045 794472 794945 794995 796726 796734 797724 809172 817063 817721 817887 823655 825124 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bdsm sex slave"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм секс доминирован"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.76%) |
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.