Query Metrics
7
Database Queries
7
Different statements
174.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.30 ms (85.37%) |
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 382266 403373 408164 408411 416926 418256 418259 421137 421578 421594 421613 424392 425472 425495 426424 430562 432318 432696 434432 434936 440852 442143 445266 445585 445814 448064 449260 449302 449320 449331 453021 456367 456387 456400 457805 460904 463072 463496 464190 464243 469195 472113 476149 476853 479285 481173 482618 482755 484218 495992 499527 500184 504962 505538 510827 511633 515002 516975 519762 526627 529438 547575 547586 555980 556115 557706 559459 559989 560833 564711 564929 581501 582220 589942 590750 595514 596347 596411 607342 617087 617636 626872 661462 662374 707427 708232 710349 715138 724335 724520 746201 750732 756165 761294 761866 770615 770662 770784 772254 781586 784493 785624 786715 787118 793642 798775 799350 799957 801157 801519 802711 806183 806895 809466 809617 811745 811845 813187 814399 820147 ] |
||||||||||||||||||||||||||||||
|
15.85 ms (9.06%) |
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 801157 806183 813187 786715 793642 799957 806895 809617 750732 770615 772254 799350 801519 802711 811745 724520 761866 746201 756165 761294 770662 724335 770784 707427 715138 781586 785624 787118 798775 382266 418256 424392 432318 449260 460904 464190 476149 421613 442143 479285 418259 421578 426424 430562 434432 445585 449302 456400 421137 434936 457805 515002 499527 495992 526627 500184 505538 511633 519762 425495 453021 445814 516975 590750 784493 809466 472113 463072 425472 449320 481173 504962 582220 559989 811845 529438 403373 408164 416926 440852 432696 408411 421594 445266 820147 814399 456367 456387 464243 469195 463496 476853 448064 449331 482755 510827 482618 484218 555980 557706 559459 581501 547575 547586 556115 560833 564711 661462 662374 708232 710349 564929 595514 596347 607342 617087 626872 589942 617636 596411 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.71%) |
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 382266 403373 408164 408411 416926 418256 418259 421137 421578 421594 421613 424392 425472 425495 426424 430562 432318 432696 434432 434936 440852 442143 445266 445585 445814 448064 449260 449302 449320 449331 453021 456367 456387 456400 457805 460904 463072 463496 464190 464243 469195 472113 476149 476853 479285 481173 482618 482755 484218 495992 499527 500184 504962 505538 510827 511633 515002 516975 519762 526627 529438 547575 547586 555980 556115 557706 559459 559989 560833 564711 564929 581501 582220 589942 590750 595514 596347 596411 607342 617087 617636 626872 661462 662374 707427 708232 710349 715138 724335 724520 746201 750732 756165 761294 761866 770615 770662 770784 772254 781586 784493 785624 786715 787118 793642 798775 799350 799957 801157 801519 802711 806183 806895 809466 809617 811745 811845 813187 814399 820147 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy face"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy face"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy face"
]
|
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.