Query Metrics
7
Database Queries
7
Different statements
190.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.36 ms (80.91%) |
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 33488 150495 388036 391874 393761 395756 395833 399367 400002 401340 408959 410080 413174 413186 416082 417295 418750 418846 418994 420400 421287 422241 429248 430801 432907 433536 436030 442952 444209 445824 446033 446480 447531 448651 452567 452755 453228 453447 453481 453773 454159 458299 459122 460359 460681 461325 467325 469216 469577 470310 470837 471189 472401 474006 475110 475113 479886 480210 480797 481333 482699 482805 482887 484312 484745 487803 488713 493263 498164 498699 504131 505607 507795 508587 509478 509699 512594 514593 515471 518015 521291 521373 522371 522443 523233 524120 524835 524981 525289 526135 526864 528437 528506 534109 542379 547686 548732 556726 556845 557363 560461 560767 562251 570143 570197 574540 579887 588231 596604 598470 609627 623759 676536 676968 702523 709637 722912 759726 766744 788007 ] |
||||||||||||||||||||||||||||||
|
23.97 ms (12.56%) |
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 534109 560767 482887 493263 676968 526135 393761 482805 452567 515471 570197 574540 388036 413174 33488 420400 408959 470837 484745 391874 410080 481333 504131 709637 759726 444209 475110 570143 418846 518015 556726 418750 480210 702523 433536 469216 470310 471189 525289 522443 524120 579887 432907 467325 514593 509478 722912 399367 436030 521373 395756 482699 453773 469577 460359 488713 418994 429248 475113 547686 522371 528506 446480 487803 453447 459122 509699 524981 150495 417295 447531 454159 395833 421287 623759 556845 512594 446033 676536 588231 528437 453481 526864 460681 788007 458299 413186 445824 479886 484312 523233 524835 560461 609627 452755 442952 461325 416082 480797 505607 508587 498164 498699 401340 542379 548732 448651 766744 474006 596604 400002 507795 521291 422241 557363 472401 453228 430801 598470 562251 ] |
||||||||||||||||||||||||||||||
|
4.48 ms (2.35%) |
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 33488 150495 388036 391874 393761 395756 395833 399367 400002 401340 408959 410080 413174 413186 416082 417295 418750 418846 418994 420400 421287 422241 429248 430801 432907 433536 436030 442952 444209 445824 446033 446480 447531 448651 452567 452755 453228 453447 453481 453773 454159 458299 459122 460359 460681 461325 467325 469216 469577 470310 470837 471189 472401 474006 475110 475113 479886 480210 480797 481333 482699 482805 482887 484312 484745 487803 488713 493263 498164 498699 504131 505607 507795 508587 509478 509699 512594 514593 515471 518015 521291 521373 522371 522443 523233 524120 524835 524981 525289 526135 526864 528437 528506 534109 542379 547686 548732 556726 556845 557363 560461 560767 562251 570143 570197 574540 579887 588231 596604 598470 609627 623759 676536 676968 702523 709637 722912 759726 766744 788007 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс молодая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс молодая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ÐüðÁð║Ðü Ðü ð╝ð¥ð╗ð¥ð┤ðÁð¢Ðîð║ð¥ð╣ Ðüð¥ÐÔǪ"
]
|
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.