Query Metrics
7
Database Queries
7
Different statements
146.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.33 ms (83.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 385491 395981 399824 400162 400191 400932 409024 411725 413972 417738 418559 423375 426009 427177 429912 431762 443733 448674 449011 453352 455225 461771 462292 465525 465951 467316 470074 471008 471347 471941 472445 473739 473968 474642 479100 479108 484718 485648 486451 487339 492259 493192 493260 496540 498033 504136 509403 514589 515187 515206 515717 521928 522832 523727 531989 542757 545602 548538 548570 549176 550705 555948 558128 558601 559120 560408 560429 565172 565471 566991 567829 571680 572763 574410 574596 581096 583622 584073 590256 591110 603622 610676 611616 612399 613832 623203 624468 628117 636593 637086 645822 647343 647906 663461 664583 664834 666804 666875 667288 667320 667496 667695 669752 670490 670507 671726 704235 728446 729635 732559 790015 792648 792663 799971 800570 808621 809932 812795 814814 825039 ] |
||||||||||||||||||||||||||||||
|
15.52 ms (10.62%) |
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 486451 523727 509403 492259 493260 542757 548570 664834 667320 669752 645822 663461 666804 670507 800570 799971 728446 729635 792648 400162 462292 448674 504136 521928 431762 814814 455225 732559 400191 479108 522832 400932 418559 429912 825039 472445 465951 449011 531989 574596 636593 792663 809932 417738 411725 471347 385491 484718 558601 515187 515206 574410 485648 667496 670490 667288 610676 812795 790015 808621 461771 473968 479100 471008 566991 671726 571680 667695 624468 514589 496540 591110 565471 545602 558128 647906 567829 623203 467316 550705 560429 572763 637086 613832 515717 487339 465525 555948 584073 647343 704235 664583 549176 612399 603622 628117 470074 413972 423375 473739 583622 581096 565172 493192 559120 666875 590256 560408 548538 409024 443733 453352 399824 471941 498033 395981 426009 474642 611616 427177 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.69%) |
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 385491 395981 399824 400162 400191 400932 409024 411725 413972 417738 418559 423375 426009 427177 429912 431762 443733 448674 449011 453352 455225 461771 462292 465525 465951 467316 470074 471008 471347 471941 472445 473739 473968 474642 479100 479108 484718 485648 486451 487339 492259 493192 493260 496540 498033 504136 509403 514589 515187 515206 515717 521928 522832 523727 531989 542757 545602 548538 548570 549176 550705 555948 558128 558601 559120 560408 560429 565172 565471 566991 567829 571680 572763 574410 574596 581096 583622 584073 590256 591110 603622 610676 611616 612399 613832 623203 624468 628117 636593 637086 645822 647343 647906 663461 664583 664834 666804 666875 667288 667320 667496 667695 669752 670490 670507 671726 704235 728446 729635 732559 790015 792648 792663 799971 800570 808621 809932 812795 814814 825039 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mmf young"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мжм секс втро young"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мжм секс втро young"
]
|
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.