Query Metrics
7
Database Queries
7
Different statements
172.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.87 ms (82.39%) |
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 358596 389765 391941 400463 400912 411342 411384 419042 424406 436031 443708 443761 443789 443793 443964 447314 451542 451565 451574 453614 454231 454262 460732 462830 463157 466085 467635 470229 470653 470743 470918 474014 474659 474674 484561 484687 484715 486391 486392 488730 489991 490682 490834 495622 497544 497572 497887 498497 500429 506051 506059 510762 512289 512334 514816 517858 522092 522789 523321 523975 535591 540902 542964 544393 546022 546684 548734 548738 548743 548753 548756 548780 551162 551220 557939 560466 562254 562369 566432 568001 570414 574781 575501 575506 575803 576405 578363 582201 583728 591192 595813 597494 598452 601994 607730 617652 619204 641756 651855 651856 659295 659321 661237 661264 670721 670965 677082 679365 683301 695125 733866 740584 742162 745404 751566 758404 766135 766325 775834 811611 ] |
||||||||||||||||||||||||||||||
|
19.77 ms (11.48%) |
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 498497 411384 560466 575803 661237 582201 400912 436031 540902 358596 454262 484715 470653 548756 470743 411342 474014 447314 443761 474674 495622 562254 460732 443789 466085 506051 484561 557939 548780 548753 659295 443708 453614 391941 470918 419042 462830 454231 486391 490682 443793 451565 451542 514816 489991 542964 488730 517858 484687 500429 470229 443964 497572 497544 679365 566432 758404 740584 670965 607730 641756 548734 551162 570414 683301 651856 670721 695125 562369 601994 742162 733866 766325 389765 523975 497887 490834 522789 535591 575501 548743 546022 583728 677082 548738 551220 617652 619204 597494 751566 811611 400463 474659 512289 523321 424406 510762 522092 546684 568001 578363 575506 544393 651855 659321 661264 574781 576405 598452 591192 595813 775834 745404 766135 451574 463157 467635 512334 486392 506059 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.76%) |
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 358596 389765 391941 400463 400912 411342 411384 419042 424406 436031 443708 443761 443789 443793 443964 447314 451542 451565 451574 453614 454231 454262 460732 462830 463157 466085 467635 470229 470653 470743 470918 474014 474659 474674 484561 484687 484715 486391 486392 488730 489991 490682 490834 495622 497544 497572 497887 498497 500429 506051 506059 510762 512289 512334 514816 517858 522092 522789 523321 523975 535591 540902 542964 544393 546022 546684 548734 548738 548743 548753 548756 548780 551162 551220 557939 560466 562254 562369 566432 568001 570414 574781 575501 575506 575803 576405 578363 582201 583728 591192 595813 597494 598452 601994 607730 617652 619204 641756 651855 651856 659295 659321 661237 661264 670721 670965 677082 679365 683301 695125 733866 740584 742162 745404 751566 758404 766135 766325 775834 811611 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"групповом секс русско…"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"группов секс русск"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.97%) |
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.