Query Metrics
7
Database Queries
7
Different statements
195.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.40 ms (85.77%) |
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 395572 395646 395756 417075 418538 421520 422561 422572 422649 423464 425878 430256 431333 439244 443312 443971 444252 444452 444807 447127 448355 451625 451752 451907 452635 453368 460302 462207 463780 465645 466987 470160 473182 474021 475720 476752 477149 481548 481780 483436 488725 492187 492273 495522 496711 496753 497432 497892 499180 501232 501283 503406 503426 506195 506297 512868 513656 513696 514152 517854 518936 520736 521241 523996 529092 532968 533018 533531 533576 533747 533949 538608 543866 546200 552064 559521 560478 574629 580685 583670 585417 598057 600111 605790 620731 626389 626735 627730 635993 641667 647891 653503 674943 679770 688369 705813 710286 716728 717849 718675 719001 722101 737161 740409 747996 749282 758216 765357 773664 775186 786049 788807 788923 797204 797799 797856 798671 807516 817115 819593 ] |
||||||||||||||||||||||||||||||
|
18.53 ms (9.49%) |
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 543866 552064 716728 705813 722101 710286 626735 585417 786049 797856 798671 807516 788923 749282 773664 740409 765357 737161 747996 717849 474021 451752 517854 488725 501232 466987 451625 431333 503406 600111 635993 758216 620731 462207 533531 425878 476752 473182 501283 819593 448355 451907 452635 481548 532968 580685 653503 560478 775186 788807 395572 395646 477149 512868 496753 495522 627730 463780 453368 443971 422561 422572 460302 447127 499180 518936 513656 605790 423464 395756 417075 418538 533949 598057 641667 523996 797204 421520 533747 546200 674943 492273 506195 688369 583670 520736 422649 430256 444452 465645 481780 492187 496711 533018 506297 533576 513696 529092 538608 574629 719001 647891 679770 559521 797799 626389 718675 439244 444252 470160 514152 497892 503426 497432 483436 521241 444807 443312 817115 475720 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.23%) |
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 395572 395646 395756 417075 418538 421520 422561 422572 422649 423464 425878 430256 431333 439244 443312 443971 444252 444452 444807 447127 448355 451625 451752 451907 452635 453368 460302 462207 463780 465645 466987 470160 473182 474021 475720 476752 477149 481548 481780 483436 488725 492187 492273 495522 496711 496753 497432 497892 499180 501232 501283 503406 503426 506195 506297 512868 513656 513696 514152 517854 518936 520736 521241 523996 529092 532968 533018 533531 533576 533747 533949 538608 543866 546200 552064 559521 560478 574629 580685 583670 585417 598057 600111 605790 620731 626389 626735 627730 635993 641667 647891 653503 674943 679770 688369 705813 710286 716728 717849 718675 719001 722101 737161 740409 747996 749282 758216 765357 773664 775186 786049 788807 788923 797204 797799 797856 798671 807516 817115 819593 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bdsm teen anal"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм teen анал"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бдсм teen анал"
]
|
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.