Query Metrics
7
Database Queries
7
Different statements
364.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
337.35 ms (92.44%) |
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 72607 95700 96341 96690 130289 191575 326134 385348 386935 387218 390871 391070 393067 393715 397273 403141 405056 405178 406086 409641 409652 410430 411694 418954 419654 421536 425655 426403 426576 428453 433217 433507 434045 443751 443984 443998 445439 450825 452061 453082 453183 455411 456384 456859 459159 462698 462700 464327 466094 466733 467602 469766 470629 471439 472161 474561 474566 474663 475907 477707 480749 482527 484693 484728 485541 485700 485735 492641 493200 494978 496100 496101 496355 501242 501247 501248 502147 504344 504481 504854 506801 510742 513265 514596 514722 515715 516744 522886 524850 525393 530020 530726 532966 533373 533563 534845 534988 535460 537114 543849 545368 585124 631207 632671 633741 636070 640136 641055 644278 647838 651634 663458 710396 716794 723512 789711 805587 810760 811459 820772 ] |
||||||||||||||||||||||||||||||
|
18.27 ms (5.01%) |
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 631207 636070 641055 644278 710396 716794 789711 805587 810760 811459 397273 406086 475907 385348 445439 456859 459159 191575 418954 450825 453082 470629 393067 411694 443998 474566 496355 513265 501247 514722 492641 493200 514596 482527 533563 506801 464327 472161 474663 393715 425655 453183 462698 466733 474561 484693 455411 467602 469766 471439 477707 485735 504854 524850 530020 532966 534988 502147 504481 533373 496101 501242 522886 525393 530726 534845 537114 480749 484728 543849 545368 647838 651634 663458 640136 632671 633741 456384 452061 462700 466094 496100 504344 516744 535460 485541 485700 494978 501248 510742 515715 72607 95700 130289 326134 96341 96690 387218 386935 391070 390871 403141 405056 405178 409652 410430 419654 421536 426403 426576 428453 433217 409641 433507 434045 443984 443751 820772 585124 723512 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (0.85%) |
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 72607 95700 96341 96690 130289 191575 326134 385348 386935 387218 390871 391070 393067 393715 397273 403141 405056 405178 406086 409641 409652 410430 411694 418954 419654 421536 425655 426403 426576 428453 433217 433507 434045 443751 443984 443998 445439 450825 452061 453082 453183 455411 456384 456859 459159 462698 462700 464327 466094 466733 467602 469766 470629 471439 472161 474561 474566 474663 475907 477707 480749 482527 484693 484728 485541 485700 485735 492641 493200 494978 496100 496101 496355 501242 501247 501248 502147 504344 504481 504854 506801 510742 513265 514596 514722 515715 516744 522886 524850 525393 530020 530726 532966 533373 533563 534845 534988 535460 537114 543849 545368 585124 631207 632671 633741 636070 640136 641055 644278 647838 651634 663458 710396 716794 723512 789711 805587 810760 811459 820772 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"group-mature"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"group mature"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"group mature"
]
|
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.