Query Metrics
7
Database Queries
7
Different statements
147.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.36 ms (82.12%) |
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 373897 387648 391428 398634 414301 417830 420358 420587 420664 421077 421093 421162 421654 423708 425549 427174 427997 428124 428315 433212 433319 433339 437537 443112 445538 445666 452404 453078 455847 461714 464366 468154 468355 469520 477587 478074 478927 480758 486333 486432 494231 496090 496729 502903 505215 510676 512608 512951 515633 520216 522851 533855 541635 541725 541831 542190 542562 543615 543918 545790 545791 545800 545802 545836 548046 548067 551941 552058 554399 555391 556525 556922 560086 567041 569059 569098 569147 574727 575302 582012 586654 586688 590879 592570 595121 597149 601710 603213 603258 604478 604558 613576 615440 616338 629886 630916 632034 632134 632655 635249 636545 643122 651601 667139 678502 700989 718661 719144 730216 758097 788119 788260 788608 791550 792550 792554 792557 801292 815002 819701 ] |
||||||||||||||||||||||||||||||
|
15.87 ms (10.74%) |
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 575302 542562 545790 632134 629886 788119 788608 791550 792550 730216 601710 421077 520216 387648 427997 510676 815002 556525 556922 801292 464366 414301 433212 443112 469520 615440 420358 543918 651601 595121 478074 496090 543615 700989 445666 468355 496729 421654 819701 477587 486432 512608 533855 560086 667139 718661 678502 554399 567041 569059 569147 616338 586688 604558 590879 632034 592570 792557 636545 391428 421162 478927 486333 512951 428315 494231 545791 421093 635249 574727 515633 452404 427174 373897 719144 502903 398634 555391 613576 453078 604478 548067 603213 758097 433319 420587 541831 545802 603258 433339 541635 437537 423708 480758 468154 586654 455847 461714 417830 420664 522851 425549 428124 445538 505215 541725 542190 545800 551941 569098 582012 545836 548046 552058 643122 597149 792554 788260 630916 632655 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (2.32%) |
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 373897 387648 391428 398634 414301 417830 420358 420587 420664 421077 421093 421162 421654 423708 425549 427174 427997 428124 428315 433212 433319 433339 437537 443112 445538 445666 452404 453078 455847 461714 464366 468154 468355 469520 477587 478074 478927 480758 486333 486432 494231 496090 496729 502903 505215 510676 512608 512951 515633 520216 522851 533855 541635 541725 541831 542190 542562 543615 543918 545790 545791 545800 545802 545836 548046 548067 551941 552058 554399 555391 556525 556922 560086 567041 569059 569098 569147 574727 575302 582012 586654 586688 590879 592570 595121 597149 601710 603213 603258 604478 604558 613576 615440 616338 629886 630916 632034 632134 632655 635249 636545 643122 651601 667139 678502 700989 718661 719144 730216 758097 788119 788260 788608 791550 792550 792554 792557 801292 815002 819701 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"дырки в сперме нарезк%…"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дырк сперм подборк"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.05%) |
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.