Query Metrics
7
Database Queries
7
Different statements
145.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.71 ms (81.45%) |
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 74239 388100 396282 396471 396569 397153 398431 418821 434914 442999 443127 445484 447340 447683 448304 450156 453124 453458 455175 456649 457091 458832 459004 459620 460194 461893 462359 464252 465187 465471 470784 473474 476146 482564 483592 484502 487025 487543 490503 491581 492102 501527 507404 511073 515482 517243 521779 522563 527020 527616 533085 536115 543500 547372 567633 569950 572737 578445 586776 597187 602705 604515 623967 634474 634804 642665 668292 673116 677322 684360 686076 689356 691368 694925 695140 720599 722709 722906 724609 727907 730343 730859 730938 731789 734397 734741 738830 741437 742839 743030 746807 748197 748751 749581 753728 756640 757290 757294 757423 758980 760160 760588 761883 770478 770754 780376 780983 785022 801375 803424 809481 809712 810591 810991 811006 816975 818455 820406 821360 823634 ] |
||||||||||||||||||||||||||||||
|
16.18 ms (11.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 758980 760160 730859 743030 748197 753728 757290 727907 746807 757294 757423 761883 722709 722906 780376 780983 810591 578445 730343 818455 450156 492102 501527 527020 569950 677322 668292 689356 586776 604515 803424 724609 741437 742839 770478 811006 770754 738830 756640 785022 810991 396569 456649 460194 473474 476146 511073 507404 487025 517243 461893 462359 487543 522563 527616 484502 634474 396282 491581 442999 816975 465471 536115 567633 572737 695140 602705 623967 459004 418821 447340 490503 515482 547372 730938 396471 533085 543500 691368 734741 760588 521779 642665 388100 731789 459620 453458 74239 397153 398431 434914 443127 820406 823634 821360 482564 465187 453124 458832 445484 447683 448304 455175 464252 483592 684360 686076 694925 673116 597187 634804 801375 809712 748751 749581 734397 720599 809481 470784 457091 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.87%) |
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 74239 388100 396282 396471 396569 397153 398431 418821 434914 442999 443127 445484 447340 447683 448304 450156 453124 453458 455175 456649 457091 458832 459004 459620 460194 461893 462359 464252 465187 465471 470784 473474 476146 482564 483592 484502 487025 487543 490503 491581 492102 501527 507404 511073 515482 517243 521779 522563 527020 527616 533085 536115 543500 547372 567633 569950 572737 578445 586776 597187 602705 604515 623967 634474 634804 642665 668292 673116 677322 684360 686076 689356 691368 694925 695140 720599 722709 722906 724609 727907 730343 730859 730938 731789 734397 734741 738830 741437 742839 743030 746807 748197 748751 749581 753728 756640 757290 757294 757423 758980 760160 760588 761883 770478 770754 780376 780983 785022 801375 803424 809481 809712 810591 810991 811006 816975 818455 820406 821360 823634 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cock big pussy"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cock большие pussy"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cock большие pussy"
]
|
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.