Query Metrics
7
Database Queries
7
Different statements
154.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.54 ms (82.31%) |
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 10006 69969 126458 384321 385303 385471 386103 386712 387270 393724 395841 396171 396270 396973 399250 399292 399511 400426 400465 400854 401313 401351 401881 405078 406203 417851 418653 418803 422501 422509 422569 423019 423398 424074 430333 435646 443417 443979 445938 446875 447417 447495 450778 451438 454250 456627 456909 464580 465816 466874 467152 467330 469531 469646 470742 471524 484088 486055 492392 495024 502302 515183 519629 520008 522443 529206 529248 538660 545517 546002 556845 558051 560541 566507 566536 567147 567153 569668 569677 570503 574808 574839 579368 581613 588376 590186 600105 603591 604624 618906 622540 650788 663372 663932 667510 668453 676445 676528 681322 682511 684590 696966 696976 712830 722679 724904 727801 731693 735587 735814 741652 744303 744315 754206 759572 759575 759642 766990 800563 821375 ] |
||||||||||||||||||||||||||||||
|
16.04 ms (10.35%) |
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 604624 744303 696966 696976 570503 400426 569677 569668 465816 470742 515183 399511 418653 766990 519629 566536 396973 495024 126458 588376 529248 567153 545517 467330 446875 393724 456627 529206 10006 387270 400854 401881 405078 422569 447495 581613 566507 603591 386712 467152 395841 443979 423398 464580 69969 821375 663932 676528 676445 712830 600105 724904 759575 735587 735814 386103 663372 423019 684590 384321 400465 401351 422501 430333 435646 447417 574808 574839 560541 546002 556845 800563 418803 456909 399250 466874 469531 471524 424074 445938 451438 401313 422509 454250 469646 484088 558051 538660 579368 567147 618906 492392 650788 443417 722679 682511 667510 668453 681322 744315 731693 754206 759642 759572 622540 741652 520008 486055 385471 385303 396171 396270 399292 406203 417851 450778 502302 522443 590186 727801 ] |
||||||||||||||||||||||||||||||
|
3.81 ms (2.46%) |
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 10006 69969 126458 384321 385303 385471 386103 386712 387270 393724 395841 396171 396270 396973 399250 399292 399511 400426 400465 400854 401313 401351 401881 405078 406203 417851 418653 418803 422501 422509 422569 423019 423398 424074 430333 435646 443417 443979 445938 446875 447417 447495 450778 451438 454250 456627 456909 464580 465816 466874 467152 467330 469531 469646 470742 471524 484088 486055 492392 495024 502302 515183 519629 520008 522443 529206 529248 538660 545517 546002 556845 558051 560541 566507 566536 567147 567153 569668 569677 570503 574808 574839 579368 581613 588376 590186 600105 603591 604624 618906 622540 650788 663372 663932 667510 668453 676445 676528 681322 682511 684590 696966 696976 712830 722679 724904 727801 731693 735587 735814 741652 744303 744315 754206 759572 759575 759642 766990 800563 821375 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl old man"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк old мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк old мужчин"
]
|
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.