Query Metrics
7
Database Queries
7
Different statements
187.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.61 ms (79.20%) |
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 406075 414865 415095 416200 421756 423317 435792 439673 439749 445735 448825 451301 451931 452161 452681 455316 457419 461061 466151 473691 477389 482317 482507 483543 488710 489866 493842 504411 507430 507584 508424 510481 512538 513001 513500 517414 518248 520952 521675 523030 523333 523711 523720 523996 524119 527076 529373 535417 540800 540802 546029 546710 546993 547423 547986 548012 550353 550409 553329 555118 556741 557569 559606 559725 560899 565281 566248 567648 569065 571137 571333 574404 574519 576312 578451 583706 585668 590851 591954 593193 595454 596786 596823 597282 597559 598760 598770 598838 599467 599979 601340 601924 601935 603873 603907 604743 605416 606049 608084 608106 608416 608737 611416 613880 617342 618943 620215 621294 622228 624151 625414 626478 628273 629095 631504 649134 653189 654374 677007 678569 ] |
||||||||||||||||||||||||||||||
|
27.70 ms (14.76%) |
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 523333 521675 473691 452681 482317 415095 547986 560899 523711 489866 550353 555118 451301 457419 547423 601935 523030 576312 626478 559606 567648 455316 493842 439749 448825 507584 677007 546710 598760 598838 451931 518248 546029 517414 520952 565281 557569 578451 508424 608084 421756 483543 524119 571137 625414 523720 423317 477389 507430 513500 608737 597282 583706 553329 631504 613880 608106 529373 461061 548012 439673 654374 622228 628273 596786 611416 414865 416200 445735 452161 540802 523996 571333 649134 595454 606049 618943 488710 574519 597559 482507 604743 624151 435792 574404 569065 629095 601924 510481 504411 550409 556741 559725 605416 603873 621294 546993 593193 540800 513001 535417 466151 527076 599979 601340 590851 406075 591954 512538 566248 678569 653189 617342 596823 585668 598770 599467 620215 603907 608416 ] |
||||||||||||||||||||||||||||||
|
3.76 ms (2.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"залил пизду спермой"
]
|
||||||||||||||||||||||||||||||
|
2.96 ms (1.58%) |
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 406075 414865 415095 416200 421756 423317 435792 439673 439749 445735 448825 451301 451931 452161 452681 455316 457419 461061 466151 473691 477389 482317 482507 483543 488710 489866 493842 504411 507430 507584 508424 510481 512538 513001 513500 517414 518248 520952 521675 523030 523333 523711 523720 523996 524119 527076 529373 535417 540800 540802 546029 546710 546993 547423 547986 548012 550353 550409 553329 555118 556741 557569 559606 559725 560899 565281 566248 567648 569065 571137 571333 574404 574519 576312 578451 583706 585668 590851 591954 593193 595454 596786 596823 597282 597559 598760 598770 598838 599467 599979 601340 601924 601935 603873 603907 604743 605416 606049 608084 608106 608416 608737 611416 613880 617342 618943 620215 621294 622228 624151 625414 626478 628273 629095 631504 649134 653189 654374 677007 678569 ] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зал вагин сперм"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.77%) |
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.