Query Metrics
7
Database Queries
7
Different statements
163.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.41 ms (83.05%) |
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 395413 395703 399162 401333 403904 413097 415591 418350 423620 424877 427585 427716 429892 432552 432805 432883 433958 436577 440634 440717 440723 444912 447543 447719 449243 450761 450801 457426 457499 457683 459111 463482 464332 464337 466986 478036 478298 483814 484424 485410 488837 492012 496164 498228 507685 509849 511320 512992 514396 517745 518106 518297 518334 518446 518519 520078 522715 523201 523420 525855 527141 528942 528952 529075 540273 544030 544972 547427 548791 551511 552471 552669 552954 557745 558186 560968 562513 565739 566029 567167 567584 568643 568756 570718 571121 571265 574089 575475 576265 598874 599505 601444 601836 602355 603893 615841 617258 619375 627803 627810 639787 657128 665051 672975 679653 682922 686406 702162 709723 722529 727665 732423 759326 760068 762158 766851 773819 777081 805366 805739 ] |
||||||||||||||||||||||||||||||
|
17.79 ms (10.91%) |
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 413097 440634 450761 450801 457499 449243 518519 498228 464332 552954 574089 567584 576265 557745 627810 603893 805366 760068 805739 440717 444912 447719 514396 483814 512992 466986 527141 565739 639787 601444 459111 423620 520078 523420 518446 436577 709723 560968 440723 403904 522715 551511 665051 552669 598874 617258 759326 415591 457426 528942 547427 568643 518297 517745 523201 484424 544030 682922 702162 672975 773819 395703 401333 418350 464337 528952 509849 525855 492012 562513 571265 544972 762158 727665 602355 427716 433958 496164 463482 568756 679653 599505 627803 427585 518334 485410 488837 601836 395413 548791 552471 570718 575475 686406 722529 566029 615841 732423 619375 777081 447543 518106 432883 457683 766851 657128 424877 432805 567167 558186 399162 571121 511320 478036 478298 432552 429892 529075 507685 540273 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.80%) |
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 395413 395703 399162 401333 403904 413097 415591 418350 423620 424877 427585 427716 429892 432552 432805 432883 433958 436577 440634 440717 440723 444912 447543 447719 449243 450761 450801 457426 457499 457683 459111 463482 464332 464337 466986 478036 478298 483814 484424 485410 488837 492012 496164 498228 507685 509849 511320 512992 514396 517745 518106 518297 518334 518446 518519 520078 522715 523201 523420 525855 527141 528942 528952 529075 540273 544030 544972 547427 548791 551511 552471 552669 552954 557745 558186 560968 562513 565739 566029 567167 567584 568643 568756 570718 571121 571265 574089 575475 576265 598874 599505 601444 601836 602355 603893 615841 617258 619375 627803 627810 639787 657128 665051 672975 679653 682922 686406 702162 709723 722529 727665 732423 759326 760068 762158 766851 773819 777081 805366 805739 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"first ass sex"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"first жоп секс"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"first жоп секс"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.99%) |
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.