Query Metrics
7
Database Queries
7
Different statements
376.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.35 ms (54.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"squirt teen"
]
|
||||||||||||||||||||||||||||||
|
147.39 ms (39.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 386303 396042 396702 402441 405988 409590 413432 413444 414081 415883 416142 416691 416706 416733 419181 421517 424646 431540 437518 441623 443333 448369 448863 450098 450640 450697 451752 452897 454004 456593 458699 466633 467895 469198 469221 473778 478285 478492 483814 485527 492525 492717 503183 503423 507503 508885 508916 509813 522973 532834 536262 536613 537904 540422 543013 544784 548167 556741 565252 586665 586899 595057 598844 603394 605309 605399 609083 619189 619361 621675 628095 628398 634497 645001 647844 648589 653487 656502 656935 658837 661510 666538 671675 679713 680712 685681 698890 712886 720885 736046 745136 749338 752602 752636 765628 765668 771829 772890 775186 777012 780603 785114 786509 787484 788807 788911 790219 794055 801275 801296 806591 807948 809228 809687 809935 811994 815430 817115 818181 825878 ] |
||||||||||||||||||||||||||||||
|
15.04 ms (4.00%) |
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 807948 467895 419181 450640 451752 556741 522973 532834 666538 586899 628398 507503 441623 485527 469221 543013 653487 720885 605399 787484 508885 586665 609083 806591 414081 658837 536262 386303 416142 416733 437518 416691 416706 443333 815430 817115 825878 645001 818181 454004 508916 540422 503183 503423 536613 537904 466633 478285 565252 671675 685681 712886 647844 648589 656502 656935 679713 680712 548167 595057 621675 605309 619189 634497 603394 786509 811994 775186 777012 780603 788807 788911 801296 736046 765628 772890 794055 801275 809687 749338 745136 771829 752602 752636 765668 698890 790219 809228 809935 396042 402441 424646 405988 448369 473778 396702 452897 456593 409590 450098 458699 478492 450697 483814 492717 509813 448863 598844 415883 785114 413432 421517 544784 469198 431540 661510 619361 628095 492525 413444 ] |
||||||||||||||||||||||||||||||
|
3.62 ms (0.96%) |
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 386303 396042 396702 402441 405988 409590 413432 413444 414081 415883 416142 416691 416706 416733 419181 421517 424646 431540 437518 441623 443333 448369 448863 450098 450640 450697 451752 452897 454004 456593 458699 466633 467895 469198 469221 473778 478285 478492 483814 485527 492525 492717 503183 503423 507503 508885 508916 509813 522973 532834 536262 536613 537904 540422 543013 544784 548167 556741 565252 586665 586899 595057 598844 603394 605309 605399 609083 619189 619361 621675 628095 628398 634497 645001 647844 648589 653487 656502 656935 658837 661510 666538 671675 679713 680712 685681 698890 712886 720885 736046 745136 749338 752602 752636 765628 765668 771829 772890 775186 777012 780603 785114 786509 787484 788807 788911 790219 794055 801275 801296 806591 807948 809228 809687 809935 811994 815430 817115 818181 825878 ] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сквирт оргазм teen"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сквирт оргазм teen"
]
|
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.