Query Metrics
7
Database Queries
7
Different statements
162.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.47 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 358864 408240 411131 415877 418449 421140 423743 428874 433420 435521 436692 437853 443070 445061 447922 448505 449206 450096 450385 451443 451475 451485 452722 453709 456294 457675 457677 457678 465856 466379 466808 467165 467341 467357 467680 467691 467912 469069 472653 473763 477475 478800 480003 485438 488909 490645 491288 494580 495082 495992 496599 498081 498876 502869 503397 506460 508755 510128 510208 510688 512394 515654 517804 518379 518555 518813 520361 520510 522298 522945 526514 544117 547686 547819 555437 565331 573360 585552 585854 586614 593659 597925 598021 598450 598684 598885 600135 605481 611767 612179 617375 624035 628063 642270 659693 677691 682273 686516 707676 710454 713727 726501 747839 747976 748337 753548 754222 755544 775090 782777 794105 796096 803369 803631 805514 809872 811496 815347 815498 822788 ] |
||||||||||||||||||||||||||||||
|
18.77 ms (11.54%) |
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 815498 822788 453709 477475 473763 506460 502869 503397 467912 555437 659693 710454 713727 677691 686516 707676 547686 597925 598885 612179 624035 585552 585854 598684 598021 611767 605481 775090 803369 796096 803631 755544 805514 747839 748337 753548 754222 428874 436692 466379 467341 358864 411131 451475 457678 465856 480003 435521 456294 433420 510128 510688 518813 485438 495992 494580 445061 815347 490645 457677 466808 488909 447922 450096 450385 452722 472653 478800 491288 526514 515654 518379 467165 467691 573360 544117 547819 565331 682273 586614 598450 617375 600135 642270 593659 628063 782777 809872 794105 811496 747976 726501 418449 448505 451443 467357 423743 457675 421140 443070 451485 469069 510208 512394 508755 518555 520510 522945 495082 517804 522298 496599 498081 520361 408240 437853 415877 449206 467680 498876 ] |
||||||||||||||||||||||||||||||
|
3.67 ms (2.25%) |
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 358864 408240 411131 415877 418449 421140 423743 428874 433420 435521 436692 437853 443070 445061 447922 448505 449206 450096 450385 451443 451475 451485 452722 453709 456294 457675 457677 457678 465856 466379 466808 467165 467341 467357 467680 467691 467912 469069 472653 473763 477475 478800 480003 485438 488909 490645 491288 494580 495082 495992 496599 498081 498876 502869 503397 506460 508755 510128 510208 510688 512394 515654 517804 518379 518555 518813 520361 520510 522298 522945 526514 544117 547686 547819 555437 565331 573360 585552 585854 586614 593659 597925 598021 598450 598684 598885 600135 605481 611767 612179 617375 624035 628063 642270 659693 677691 682273 686516 707676 710454 713727 726501 747839 747976 748337 753548 754222 755544 775090 782777 794105 796096 803369 803631 805514 809872 811496 815347 815498 822788 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"as well"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"well"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"well"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.05%) |
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.