Query Metrics
7
Database Queries
7
Different statements
152.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.50 ms (80.19%) |
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 391772 427057 437759 438596 438979 446805 446845 447071 449105 449643 450524 451549 456265 460476 461500 461958 462267 463839 466266 466311 467758 470562 473298 475962 476381 476976 480975 482933 484920 486364 487612 494432 495030 495327 495499 497216 498164 500988 501920 503099 503472 503512 503943 504304 505578 505851 506479 510316 519101 520610 522268 524438 541210 544562 547055 548755 550495 551029 552549 557943 557977 558213 562647 562927 564283 579886 582380 582595 590309 593463 596622 597543 600063 601257 607229 610779 611788 613882 616913 620189 621288 623013 624140 639126 653219 675618 678807 695820 696577 697996 712380 715675 718561 725210 727376 730928 732822 737563 739278 739901 740009 744381 747797 750728 761611 761624 766484 771895 781909 782125 784288 788690 793892 798908 800707 807351 818830 818835 819870 824749 ] |
||||||||||||||||||||||||||||||
|
21.70 ms (14.21%) |
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 696577 547055 639126 597543 610779 623013 793892 784288 737563 761624 715675 782125 473298 524438 596622 476976 819870 541210 562927 675618 697996 613882 601257 616913 593463 727376 766484 739901 620189 781909 807351 391772 486364 500988 824749 460476 438596 449105 450524 438979 446805 446845 447071 449643 466311 456265 503943 505851 503512 520610 487612 497216 510316 519101 498164 552549 818835 579886 551029 695820 739278 750728 501920 611788 462267 463839 466266 451549 467758 470562 475962 522268 557943 504304 495327 503099 503472 495499 544562 476381 653219 557977 548755 480975 621288 437759 461500 506479 582380 582595 558213 482933 484920 495030 818830 550495 562647 564283 712380 678807 718561 607229 600063 624140 590309 788690 725210 730928 740009 744381 798908 761611 732822 747797 771895 800707 461958 505578 494432 427057 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.69%) |
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 391772 427057 437759 438596 438979 446805 446845 447071 449105 449643 450524 451549 456265 460476 461500 461958 462267 463839 466266 466311 467758 470562 473298 475962 476381 476976 480975 482933 484920 486364 487612 494432 495030 495327 495499 497216 498164 500988 501920 503099 503472 503512 503943 504304 505578 505851 506479 510316 519101 520610 522268 524438 541210 544562 547055 548755 550495 551029 552549 557943 557977 558213 562647 562927 564283 579886 582380 582595 590309 593463 596622 597543 600063 601257 607229 610779 611788 613882 616913 620189 621288 623013 624140 639126 653219 675618 678807 695820 696577 697996 712380 715675 718561 725210 727376 730928 732822 737563 739278 739901 740009 744381 747797 750728 761611 761624 766484 771895 781909 782125 784288 788690 793892 798908 800707 807351 818830 818835 819870 824749 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian girl hidden"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск девушк скрыт"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.32 ms (0.87%) |
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.