Query Metrics
7
Database Queries
7
Different statements
200.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.78 ms (84.86%) |
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 6666 108018 321410 384853 387174 391258 395227 396575 396585 396797 397945 398204 398998 399516 410956 411257 416041 418897 419078 424655 428296 428759 428772 431629 432169 435348 436302 443828 444546 448198 449575 451449 454363 455477 456405 456588 457012 457313 458915 459073 459436 459624 459993 460123 461565 462726 463302 465874 471386 471985 473236 473633 474713 475929 477645 479681 479742 481006 483714 484054 487610 488855 489902 490653 496135 496992 500008 500984 502209 508805 510179 512011 514618 516223 516564 517110 517854 518421 521748 523137 526011 527349 528506 538202 542489 546310 552070 552696 554117 558847 559155 562496 562736 562792 568959 569854 570528 570656 572116 574618 580044 583320 586692 595969 598439 600208 600619 600629 601504 603072 610469 610493 650881 650976 654836 655611 664804 735373 813007 814010 ] |
||||||||||||||||||||||||||||||
|
17.83 ms (8.91%) |
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 436302 456588 459624 496135 559155 562496 518421 384853 395227 391258 396797 431629 418897 455477 457313 459073 474713 517110 523137 479681 562736 574618 387174 397945 398998 449575 459436 463302 396585 435348 477645 479742 443828 461565 465874 471386 473236 411257 462726 489902 490653 516564 512011 475929 481006 500984 459993 471985 521748 526011 814010 568959 650881 664804 655611 546310 554117 580044 601504 610469 610493 600629 600208 600619 735373 813007 496992 6666 432169 586692 595969 321410 456405 444546 517854 514618 399516 419078 428772 424655 428296 428759 448198 487610 460123 508805 502209 516223 451449 458915 473633 454363 488855 528506 527349 538202 500008 510179 558847 598439 396575 398204 410956 484054 552070 569854 570528 570656 583320 552696 654836 572116 108018 416041 542489 562792 650976 603072 483714 457012 ] |
||||||||||||||||||||||||||||||
|
4.05 ms (2.03%) |
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 6666 108018 321410 384853 387174 391258 395227 396575 396585 396797 397945 398204 398998 399516 410956 411257 416041 418897 419078 424655 428296 428759 428772 431629 432169 435348 436302 443828 444546 448198 449575 451449 454363 455477 456405 456588 457012 457313 458915 459073 459436 459624 459993 460123 461565 462726 463302 465874 471386 471985 473236 473633 474713 475929 477645 479681 479742 481006 483714 484054 487610 488855 489902 490653 496135 496992 500008 500984 502209 508805 510179 512011 514618 516223 516564 517110 517854 518421 521748 523137 526011 527349 528506 538202 542489 546310 552070 552696 554117 558847 559155 562496 562736 562792 568959 569854 570528 570656 572116 574618 580044 583320 586692 595969 598439 600208 600619 600629 601504 603072 610469 610493 650881 650976 654836 655611 664804 735373 813007 814010 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"девки с большими членами"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девк большой большие член"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.90%) |
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.