Query Metrics
7
Database Queries
7
Different statements
186.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.13 ms (82.46%) |
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 390831 391941 418417 421146 424433 425129 436032 436042 436178 443334 443383 443764 443777 443779 443796 447810 456437 457791 457793 460739 462305 468527 469764 470291 470541 470590 473780 474652 474654 474680 474689 474693 474696 474702 480059 484558 484629 484651 484665 484678 484696 484705 484724 484737 488726 490836 497569 497871 497923 510756 514404 521438 530373 531172 531177 532954 533697 533726 533741 534631 536290 542864 542956 543731 547997 552267 554743 555805 558131 565247 567304 567581 568315 572042 575173 575810 579620 586770 587864 590411 596643 597494 597566 597963 598057 599361 599969 600354 601478 614747 621482 621612 622817 627652 631193 631247 632695 644968 647340 647936 648845 650155 662137 683259 683261 683262 683264 696997 702166 716030 716032 716043 731665 733870 733884 775860 775866 775958 805487 825812 ] |
||||||||||||||||||||||||||||||
|
22.62 ms (12.10%) |
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 497923 480059 531177 683259 443383 462305 536290 531172 421146 600354 443334 474680 510756 733884 474693 443777 484629 621482 579620 683262 533741 534631 575173 390831 488726 597566 596643 775866 696997 484678 554743 456437 436042 567581 572042 514404 533697 567304 601478 775958 484558 627652 474652 484705 497569 547997 644968 568315 650155 443796 683261 733870 631247 621612 424433 484651 484737 590411 443764 443779 474696 447810 597494 470541 731665 825812 552267 565247 598057 586770 716032 469764 716030 490836 647936 683264 484724 474654 555805 460739 622817 533726 418417 775860 575810 468527 457791 543731 470291 532954 474702 702166 473780 716043 470590 542956 662137 542864 805487 484696 597963 497871 599969 614747 648845 530373 436032 474689 436178 457793 484665 425129 647340 632695 587864 521438 631193 599361 558131 391941 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (1.77%) |
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 390831 391941 418417 421146 424433 425129 436032 436042 436178 443334 443383 443764 443777 443779 443796 447810 456437 457791 457793 460739 462305 468527 469764 470291 470541 470590 473780 474652 474654 474680 474689 474693 474696 474702 480059 484558 484629 484651 484665 484678 484696 484705 484724 484737 488726 490836 497569 497871 497923 510756 514404 521438 530373 531172 531177 532954 533697 533726 533741 534631 536290 542864 542956 543731 547997 552267 554743 555805 558131 565247 567304 567581 568315 572042 575173 575810 579620 586770 587864 590411 596643 597494 597566 597963 598057 599361 599969 600354 601478 614747 621482 621612 622817 627652 631193 631247 632695 644968 647340 647936 648845 650155 662137 683259 683261 683262 683264 696997 702166 716030 716032 716043 731665 733870 733884 775860 775866 775958 805487 825812 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русскую в жопу толпой"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск анал группов секс"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск анал группов секс"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.84%) |
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.