Query Metrics
7
Database Queries
7
Different statements
200.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.37 ms (87.27%) |
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 6741 7219 251476 373842 385505 386813 391253 392748 393937 394853 395679 395733 396639 397053 397436 398231 400143 400209 400450 400458 400469 400927 401313 402870 404276 406501 408774 410897 412289 418493 419629 423301 429300 429543 432760 434638 447562 453785 456608 458196 461918 463857 468711 469846 473004 476808 476913 477823 479190 487093 489534 489569 495759 502641 509025 509952 510677 511713 512276 512604 517668 519976 520950 529248 531409 538197 538204 538372 541250 543892 546603 547823 548034 548775 552924 558131 559785 560541 560573 562886 563800 563878 565417 565951 566475 566621 570013 570269 570493 570650 571615 571918 573950 575056 575516 575740 576271 576323 576389 579620 581658 584322 586789 592300 592329 593138 595819 597242 627813 630529 656545 665107 667563 669577 707915 716236 719150 722912 748416 803658 ] |
||||||||||||||||||||||||||||||
|
16.35 ms (8.14%) |
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 566475 592300 748416 7219 502641 511713 538204 579620 400143 394853 396639 519976 576271 543892 560573 552924 592329 597242 400927 489569 538372 509025 373842 453785 716236 400450 429300 489534 400458 571615 575740 559785 570493 570013 593138 463857 541250 669577 479190 558131 509952 627813 566621 547823 395679 386813 392748 391253 397053 548034 565417 667563 410897 495759 487093 385505 419629 456608 565951 575056 560541 722912 586789 630529 477823 429543 400469 401313 418493 408774 473004 563878 476808 404276 529248 412289 656545 402870 476913 398231 531409 546603 548775 576323 468711 510677 665107 570269 571918 803658 707915 393937 397436 512276 538197 395733 406501 719150 434638 520950 584322 432760 251476 581658 512604 6741 562886 400209 423301 469846 576389 447562 458196 461918 517668 570650 575516 563800 573950 595819 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.56%) |
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 6741 7219 251476 373842 385505 386813 391253 392748 393937 394853 395679 395733 396639 397053 397436 398231 400143 400209 400450 400458 400469 400927 401313 402870 404276 406501 408774 410897 412289 418493 419629 423301 429300 429543 432760 434638 447562 453785 456608 458196 461918 463857 468711 469846 473004 476808 476913 477823 479190 487093 489534 489569 495759 502641 509025 509952 510677 511713 512276 512604 517668 519976 520950 529248 531409 538197 538204 538372 541250 543892 546603 547823 548034 548775 552924 558131 559785 560541 560573 562886 563800 563878 565417 565951 566475 566621 570013 570269 570493 570650 571615 571918 573950 575056 575516 575740 576271 576323 576389 579620 581658 584322 586789 592300 592329 593138 595819 597242 627813 630529 656545 665107 667563 669577 707915 716236 719150 722912 748416 803658 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð╝ð¥ð╗ð¥ð┤ð¥ð╣ ð┤ðÁð▓ÐâÐêð║ð░ ÐüðÁð║ÐüðÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодой девушк секс"
]
|
||||||||||||||||||||||||||||||
|
1.25 ms (0.62%) |
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.