Query Metrics
7
Database Queries
7
Different statements
383.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.45 ms (54.66%) |
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 46446 271290 324573 382606 383018 386329 392552 395573 409209 420063 420223 426411 435348 446303 451951 452644 454933 456182 466166 468162 469085 470150 473824 483814 485147 491683 502422 510440 510452 518467 521287 523857 526776 527629 528781 534227 540869 547289 548716 549036 561826 561841 561850 563459 567145 567991 573255 573871 575063 575492 579580 583869 591733 592345 592808 593193 601556 603536 607501 609879 610173 622953 641660 654416 660905 661269 665428 668845 669414 675455 676599 676619 677335 680189 693043 699151 701452 701794 701817 703877 725079 731199 737809 739688 741250 748675 753266 753286 753343 753365 753821 753861 754695 763270 767530 770834 773216 776944 779393 779920 786063 789232 790088 797030 798771 799403 801189 806014 806689 810930 814101 817760 818458 818701 820489 820619 825565 825745 826795 827727 ] |
||||||||||||||||||||||||||||||
|
152.27 ms (39.73%) |
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 46446 271290 324573 382606 383018 386329 392552 395573 409209 420063 420223 426411 435348 446303 451951 452644 454933 456182 466166 468162 469085 470150 473824 483814 485147 491683 502422 510440 510452 518467 521287 523857 526776 527629 528781 534227 540869 547289 548716 549036 561826 561841 561850 563459 567145 567991 573255 573871 575063 575492 579580 583869 591733 592345 592808 593193 601556 603536 607501 609879 610173 622953 641660 654416 660905 661269 665428 668845 669414 675455 676599 676619 677335 680189 693043 699151 701452 701794 701817 703877 725079 731199 737809 739688 741250 748675 753266 753286 753343 753365 753821 753861 754695 763270 767530 770834 773216 776944 779393 779920 786063 789232 790088 797030 798771 799403 801189 806014 806689 810930 814101 817760 818458 818701 820489 820619 825565 825745 826795 827727 ] |
||||||||||||||||||||||||||||||
|
14.62 ms (3.81%) |
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 523857 801189 786063 409209 593193 452644 470150 502422 548716 575492 561841 575063 573871 641660 592345 609879 446303 473824 466166 469085 483814 528781 395573 426411 579580 661269 526776 527629 491683 521287 510440 665428 382606 603536 420063 540869 534227 748675 435348 468162 820619 660905 668845 669414 693043 607501 610173 806689 806014 741250 790088 753286 767530 383018 818701 826795 676599 703877 797030 739688 754695 789232 271290 46446 573255 676619 725079 392552 699151 737809 810930 753343 763270 731199 485147 567145 680189 420223 820489 817760 827727 654416 701794 677335 753365 753266 753821 773216 386329 770834 753861 798771 456182 510452 561826 561850 549036 622953 454933 518467 583869 547289 591733 451951 324573 814101 825565 818458 825745 567991 701452 675455 701817 563459 592808 601556 779393 779920 799403 776944 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck teens"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс teens"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс teens"
]
|
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.