Query Metrics
7
Database Queries
7
Different statements
187.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.41 ms (86.06%) |
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 387480 413389 413392 416682 416708 416712 416731 419461 420277 428924 432674 434903 439031 443236 445651 448604 448854 451336 451651 453223 459198 462848 465148 466476 468943 470479 473213 475806 477761 478030 479723 480450 483737 487414 497693 505140 509892 512442 518187 519722 524678 534537 541274 541377 550916 562578 564501 567127 579457 582303 586876 589042 592259 594236 595145 596610 598616 601367 602109 602268 618231 625633 628095 632920 640047 657489 657527 658774 658802 660387 661455 673954 679643 680816 683297 692657 692943 697614 703945 715584 722428 728755 736813 738126 738490 738822 740315 740931 741557 742363 744021 744033 745128 752603 752620 752636 752650 752652 752660 752681 752712 765684 766941 770262 780192 782547 783043 785814 786895 786899 787510 792706 792735 793280 793283 794131 808337 813195 824352 ] |
||||||||||||||||||||||||||||||
|
16.78 ms (8.95%) |
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 598616 601367 596610 744033 752650 466476 679643 692943 564501 640047 413389 443236 416712 477761 459198 420277 478030 428924 387480 439031 416682 470479 445651 487414 512442 524678 518187 541274 683297 752660 752636 416708 468943 480450 451336 602268 512930 657527 658774 661455 692657 697614 786899 793283 740315 741557 766941 740931 783043 792706 793280 534537 722428 416731 419461 453223 479723 462848 473213 505140 519722 497693 595145 625633 787510 448604 451651 824352 728755 434903 550916 562578 582303 541377 579457 715584 658802 660387 589042 782547 785814 786895 738126 752603 752681 794131 808337 752652 752712 770262 736813 738822 742363 738490 744021 745128 765684 602109 618231 703945 780192 792735 628095 813195 432674 448854 483737 567127 592259 413392 465148 680816 586876 632920 752620 475806 509892 657489 673954 594236 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.59%) |
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 387480 413389 413392 416682 416708 416712 416731 419461 420277 428924 432674 434903 439031 443236 445651 448604 448854 451336 451651 453223 459198 462848 465148 466476 468943 470479 473213 475806 477761 478030 479723 480450 483737 487414 497693 505140 509892 512442 518187 519722 524678 534537 541274 541377 550916 562578 564501 567127 579457 582303 586876 589042 592259 594236 595145 596610 598616 601367 602109 602268 618231 625633 628095 632920 640047 657489 657527 658774 658802 660387 661455 673954 679643 680816 683297 692657 692943 697614 703945 715584 722428 728755 736813 738126 738490 738822 740315 740931 741557 742363 744021 744033 745128 752603 752620 752636 752650 752652 752660 752681 752712 765684 766941 770262 780192 782547 783043 785814 786895 786899 787510 792706 792735 793280 793283 794131 808337 813195 824352 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur teen dildo"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск teen дилд"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск teen дилд"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.71%) |
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.