Query Metrics
7
Database Queries
7
Different statements
182.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.61 ms (83.49%) |
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 418013 418440 419904 420692 424190 424200 426139 427950 428257 434557 437518 439372 440445 442367 444784 445324 447240 448280 449557 452299 452324 454312 455525 455785 456296 457884 457886 459317 459535 459559 460431 460879 469019 475984 476476 477695 486868 486880 486904 486964 488995 489729 490060 502648 502779 505526 507514 508371 509163 512502 514486 514640 515065 515982 517308 518151 519377 519517 519558 524934 540684 541749 542516 547423 553031 554246 557089 561441 561944 564162 564327 566110 567757 567837 570728 571433 573800 585166 585798 586658 588934 592614 593596 596856 598466 598762 604671 605762 616294 619965 620266 621387 624938 627281 627727 627817 639009 642875 643939 649055 668972 679657 680267 682303 689436 696576 723209 732915 734314 746331 765552 766041 784838 789614 791358 791758 793818 801635 802812 ] |
||||||||||||||||||||||||||||||
|
19.85 ms (10.86%) |
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 564162 605762 440445 828272 585166 801635 418440 419904 514486 428257 448280 571433 642875 418013 561441 734314 452299 460879 682303 447240 620266 649055 553031 541749 542516 567757 588934 509163 643939 442367 561944 424200 452324 456296 475984 488995 457884 454312 519517 524934 570728 679657 616294 459535 519377 519558 547423 564327 566110 502648 627281 668972 791758 793818 507514 567837 627727 490060 619965 723209 515065 512502 439372 627817 420692 427950 486880 489729 746331 486868 573800 598762 765552 505526 518151 460431 639009 455785 802812 540684 596856 592614 766041 784838 789614 469019 604671 554246 624938 437518 514640 586658 459317 426139 502779 459559 457886 508371 517308 515982 557089 689436 621387 598466 791358 696576 593596 444784 486964 434557 732915 445324 455525 449557 477695 680267 585798 476476 486904 424190 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.64%) |
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 418013 418440 419904 420692 424190 424200 426139 427950 428257 434557 437518 439372 440445 442367 444784 445324 447240 448280 449557 452299 452324 454312 455525 455785 456296 457884 457886 459317 459535 459559 460431 460879 469019 475984 476476 477695 486868 486880 486904 486964 488995 489729 490060 502648 502779 505526 507514 508371 509163 512502 514486 514640 515065 515982 517308 518151 519377 519517 519558 524934 540684 541749 542516 547423 553031 554246 557089 561441 561944 564162 564327 566110 567757 567837 570728 571433 573800 585166 585798 586658 588934 592614 593596 596856 598466 598762 604671 605762 616294 619965 620266 621387 624938 627281 627727 627817 639009 642875 643939 649055 668972 679657 680267 682303 689436 696576 723209 732915 734314 746331 765552 766041 784838 789614 791358 791758 793818 801635 802812 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov cum anal"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов cum анал"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов cum анал"
]
|
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.