Query Metrics
7
Database Queries
7
Different statements
228.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
197.19 ms (86.44%) |
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 2332 28591 76122 382488 382585 383173 389897 391269 395392 395413 397714 401589 403628 409010 412367 413253 416082 417395 420130 420507 420864 423787 425609 427540 430508 432266 433950 437347 437791 437833 454853 455509 455696 457378 459466 460211 460488 460653 460767 461079 461625 462596 469055 472312 473985 474904 480968 481154 483243 487417 489857 490809 491514 492516 493469 496519 499433 505191 506301 512927 520555 520576 520706 521760 523818 527195 542096 548701 551370 552073 552148 552624 560341 560469 567538 567770 569689 572630 575426 582526 586803 592418 597231 598033 599317 603679 604086 623442 625395 626863 628589 629752 649507 668964 676388 676483 680517 699459 704261 709306 711600 715402 722913 726954 735800 773414 775288 776191 783206 788132 792322 795674 797095 797867 798177 799689 800231 810568 813728 819932 ] |
||||||||||||||||||||||||||||||
|
20.16 ms (8.84%) |
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 2332 412367 520576 520555 699459 649507 704261 432266 462596 417395 603679 813728 569689 722913 629752 625395 490809 413253 455696 567770 582526 542096 423787 457378 427540 460211 483243 521760 527195 437347 506301 416082 487417 735800 726954 783206 382488 623442 776191 425609 788132 461079 496519 819932 668964 680517 775288 792322 76122 604086 799689 795674 469055 512927 797867 401589 382585 592418 493469 709306 567538 430508 599317 474904 676483 800231 773414 810568 395413 420864 551370 575426 676388 715402 552148 586803 433950 397714 461625 520706 491514 572630 798177 391269 437833 492516 460653 560341 628589 626863 499433 420130 383173 454853 523818 548701 711600 797095 28591 395392 481154 472312 597231 389897 480968 460767 459466 473985 437791 460488 505191 403628 420507 455509 489857 552624 560469 552073 598033 409010 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (1.39%) |
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 2332 28591 76122 382488 382585 383173 389897 391269 395392 395413 397714 401589 403628 409010 412367 413253 416082 417395 420130 420507 420864 423787 425609 427540 430508 432266 433950 437347 437791 437833 454853 455509 455696 457378 459466 460211 460488 460653 460767 461079 461625 462596 469055 472312 473985 474904 480968 481154 483243 487417 489857 490809 491514 492516 493469 496519 499433 505191 506301 512927 520555 520576 520706 521760 523818 527195 542096 548701 551370 552073 552148 552624 560341 560469 567538 567770 569689 572630 575426 582526 586803 592418 597231 598033 599317 603679 604086 623442 625395 626863 628589 629752 649507 668964 676388 676483 680517 699459 704261 709306 711600 715402 722913 726954 735800 773414 775288 776191 783206 788132 792322 795674 797095 797867 798177 799689 800231 810568 813728 819932 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая сиськ секс"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful tits sex"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.