Query Metrics
7
Database Queries
7
Different statements
170.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.53 ms (83.60%) |
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 7065 61762 145335 212982 233397 385562 388722 390045 391392 391521 391574 391588 394218 395925 400989 401055 407754 411704 412975 454194 460923 464339 465592 465825 465834 466206 470017 474106 474478 474479 474480 474482 476284 479053 481955 482322 484379 485916 486470 504850 522589 523572 525528 530357 532698 533022 546716 547568 556630 561777 566327 566940 591260 601951 608355 615667 620199 665200 665877 665881 666137 666807 667207 667500 667884 712321 714647 716460 721388 721392 721570 724274 724276 725561 727898 728317 732171 740530 741027 745055 746638 748242 756058 757641 773547 774763 781670 781710 781734 782160 782227 782261 782270 784669 785867 788461 788787 788823 788873 789527 789535 789536 789969 793529 794629 794678 802409 804009 807602 807639 808866 816766 816791 818665 818720 818770 823586 823637 823909 828373 ] |
||||||||||||||||||||||||||||||
|
17.67 ms (10.36%) |
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 388722 784669 530357 532698 391574 390045 391392 412975 407754 486470 481955 460923 464339 465592 474479 479053 504850 522589 523572 566940 546716 556630 566327 591260 789536 727898 748242 725561 728317 391588 400989 391521 474480 474482 476284 385562 474106 411704 465825 465834 466206 470017 482322 454194 474478 485916 484379 145335 394218 61762 7065 816766 818665 816791 823637 818720 818770 823586 823909 828373 525528 533022 547568 561777 665881 721392 721570 665200 666137 665877 666807 667207 667500 667884 712321 714647 716460 615667 601951 620199 608355 774763 781670 781710 781734 782227 782270 785867 788873 789535 802409 804009 807639 782261 788787 789527 794629 724276 782160 788823 789969 793529 794678 807602 808866 724274 756058 732171 741027 745055 740530 746638 757641 773547 721388 788461 212982 233397 395925 401055 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.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 7065 61762 145335 212982 233397 385562 388722 390045 391392 391521 391574 391588 394218 395925 400989 401055 407754 411704 412975 454194 460923 464339 465592 465825 465834 466206 470017 474106 474478 474479 474480 474482 476284 479053 481955 482322 484379 485916 486470 504850 522589 523572 525528 530357 532698 533022 546716 547568 556630 561777 566327 566940 591260 601951 608355 615667 620199 665200 665877 665881 666137 666807 667207 667500 667884 712321 714647 716460 721388 721392 721570 724274 724276 725561 727898 728317 732171 740530 741027 745055 746638 748242 756058 757641 773547 774763 781670 781710 781734 782160 782227 782261 782270 784669 785867 788461 788787 788823 788873 789527 789535 789536 789969 793529 794629 794678 802409 804009 807602 807639 808866 816766 816791 818665 818720 818770 823586 823637 823909 828373 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature old young"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature old young"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature old young"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.95%) |
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.