Query Metrics
7
Database Queries
7
Different statements
210.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.10 ms (83.22%) |
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 387328 396350 398200 399017 416969 418690 425887 425889 437793 447912 447970 461938 475317 505804 545415 545701 551107 551199 552514 556018 557086 559961 561635 561649 561657 561673 562190 562842 565158 567089 567346 567957 568121 568509 569070 570310 570537 572786 574578 575109 576105 576274 576395 578503 580236 584539 585982 591240 592071 592381 592444 592518 595359 595388 595458 596039 597236 597271 598444 598508 598553 600348 603686 604289 608765 609878 610278 614261 620141 624915 625960 631948 632626 634168 637520 638985 644923 647850 648593 651620 652939 656575 659161 662537 677042 677332 677343 677369 679040 679051 679772 702634 713364 714497 715934 718638 718656 720069 720450 720810 721366 722542 722889 725409 727669 728384 730802 731933 739077 740920 747451 755178 758979 781051 788540 799272 800587 804373 811832 812348 ] |
||||||||||||||||||||||||||||||
|
23.99 ms (11.40%) |
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 652939 570310 625960 804373 718638 812348 727669 800587 648593 562190 604289 659161 596039 610278 418690 416969 568509 608765 437793 576105 561657 600348 598553 592381 461938 715934 781051 475317 718656 425887 647850 595359 609878 728384 730802 591240 597271 603686 739077 447970 677343 713364 755178 567957 637520 597236 758979 387328 556018 592444 569070 561673 561635 740920 396350 595388 811832 551199 447912 576395 714497 562842 568121 677332 592071 585982 575109 567346 624915 638985 552514 662537 720069 799272 720810 632626 572786 677369 677042 679040 620141 398200 584539 679051 720450 721366 722542 545415 598508 592518 788540 731933 425889 595458 545701 399017 559961 747451 644923 565158 557086 570537 578503 574578 679772 656575 651620 702634 576274 634168 598444 725409 631948 722889 580236 567089 614261 505804 551107 561649 ] |
||||||||||||||||||||||||||||||
|
3.77 ms (1.79%) |
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 387328 396350 398200 399017 416969 418690 425887 425889 437793 447912 447970 461938 475317 505804 545415 545701 551107 551199 552514 556018 557086 559961 561635 561649 561657 561673 562190 562842 565158 567089 567346 567957 568121 568509 569070 570310 570537 572786 574578 575109 576105 576274 576395 578503 580236 584539 585982 591240 592071 592381 592444 592518 595359 595388 595458 596039 597236 597271 598444 598508 598553 600348 603686 604289 608765 609878 610278 614261 620141 624915 625960 631948 632626 634168 637520 638985 644923 647850 648593 651620 652939 656575 659161 662537 677042 677332 677343 677369 679040 679051 679772 702634 713364 714497 715934 718638 718656 720069 720450 720810 721366 722542 722889 725409 727669 728384 730802 731933 739077 740920 747451 755178 758979 781051 788540 799272 800587 804373 811832 812348 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small anal sex"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая анал секс"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.