Query Metrics
7
Database Queries
7
Different statements
196.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.92 ms (90.59%) |
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 6609 146112 382768 382935 385008 387393 388067 394059 397587 398824 398999 401522 401588 408581 411729 427803 434022 434066 434136 446759 449335 450968 451879 453316 460192 464283 464471 466624 467792 468275 474891 478519 478637 480980 484142 484210 487943 492186 494598 495888 497576 497893 497909 504169 508986 510785 511024 513010 513170 516242 520846 522422 524319 525495 532927 533805 534036 535742 541228 541519 544453 544870 548194 550538 553711 558694 562959 566817 568499 577107 582985 583877 586582 590264 595576 601137 601449 603664 611364 611894 614193 614484 616227 620880 625246 651716 657527 660467 661007 663293 670034 679134 686610 696071 698459 700452 701001 704072 708446 708522 714323 722314 722405 739809 756949 758061 761913 772650 794179 798481 804198 806623 813553 814132 815895 817208 820817 821557 824028 827830 ] |
||||||||||||||||||||||||||||||
|
10.18 ms (5.18%) |
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 611364 698459 722314 388067 146112 408581 394059 434066 487943 525495 495888 544453 562959 583877 601449 586582 616227 434136 497893 513010 524319 590264 614193 449335 484142 516242 401522 427803 434022 446759 504169 533805 704072 696071 651716 661007 614484 625246 620880 611894 804198 772650 798481 806623 761913 739809 758061 756949 794179 467792 468275 453316 510785 601137 398824 411729 484210 464283 520846 535742 497909 460192 550538 553711 670034 603664 595576 401588 464471 474891 478519 478637 480980 450968 466624 508986 494598 511024 497576 382768 385008 382935 6609 387393 397587 398999 813553 814132 815895 820817 821557 824028 817208 827830 492186 451879 513170 522422 534036 532927 544870 566817 541228 548194 558694 568499 541519 577107 582985 657527 679134 686610 700452 701001 708446 708522 714323 722405 660467 663293 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.16%) |
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 6609 146112 382768 382935 385008 387393 388067 394059 397587 398824 398999 401522 401588 408581 411729 427803 434022 434066 434136 446759 449335 450968 451879 453316 460192 464283 464471 466624 467792 468275 474891 478519 478637 480980 484142 484210 487943 492186 494598 495888 497576 497893 497909 504169 508986 510785 511024 513010 513170 516242 520846 522422 524319 525495 532927 533805 534036 535742 541228 541519 544453 544870 548194 550538 553711 558694 562959 566817 568499 577107 582985 583877 586582 590264 595576 601137 601449 603664 611364 611894 614193 614484 616227 620880 625246 651716 657527 660467 661007 663293 670034 679134 686610 696071 698459 700452 701001 704072 708446 708522 714323 722314 722405 739809 756949 758061 761913 772650 794179 798481 804198 806623 813553 814132 815895 817208 820817 821557 824028 827830 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vagina red"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин red"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вагин red"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.