Query Metrics
7
Database Queries
7
Different statements
176.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.60 ms (85.99%) |
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 11254 145335 187516 187800 385007 385653 387179 388712 388862 389611 390571 395573 397871 400128 400139 407708 407754 407761 409390 411408 411627 413457 424480 424658 428103 439643 439819 440968 449428 451991 452061 466235 469575 470213 470306 470964 474095 476234 479078 481918 484365 486169 490907 491910 491993 504354 506908 518563 518867 528093 529682 532755 534317 544493 544504 546548 563180 566155 567420 591133 591145 592428 600384 600506 620256 633115 634858 671458 714153 718581 723377 726332 726503 726589 727513 727818 727898 728452 729209 730076 731752 731754 731756 731796 731832 732258 740185 741904 748130 748151 748225 748232 765299 775571 781019 781485 788877 789527 790983 792822 794629 794651 798905 803918 807376 808040 808263 808690 810061 811013 815940 817208 817597 818206 819823 820384 820683 824021 824604 824621 ] |
||||||||||||||||||||||||||||||
|
14.56 ms (8.26%) |
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 788877 781019 567420 486169 781485 817597 407761 544504 748232 731756 731796 748151 798905 390571 544493 731754 387179 407754 469575 811013 727898 794651 479078 466235 591145 409390 792822 563180 718581 820384 729209 529682 474095 728452 600384 790983 726503 727818 765299 808690 400128 400139 534317 723377 726332 187800 439643 470306 490907 824021 385653 731752 732258 11254 748225 789527 395573 532755 824604 817208 740185 389611 824621 385007 546548 803918 451991 470213 518563 388862 388712 413457 818206 476234 634858 810061 470964 491993 815940 424480 808263 620256 741904 727513 714153 397871 407708 145335 591133 794629 566155 506908 452061 819823 592428 411408 600506 726589 449428 481918 528093 491910 484365 440968 439819 633115 775571 731832 807376 730076 808040 187516 411627 424658 671458 748130 504354 428103 820683 518867 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (1.91%) |
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 11254 145335 187516 187800 385007 385653 387179 388712 388862 389611 390571 395573 397871 400128 400139 407708 407754 407761 409390 411408 411627 413457 424480 424658 428103 439643 439819 440968 449428 451991 452061 466235 469575 470213 470306 470964 474095 476234 479078 481918 484365 486169 490907 491910 491993 504354 506908 518563 518867 528093 529682 532755 534317 544493 544504 546548 563180 566155 567420 591133 591145 592428 600384 600506 620256 633115 634858 671458 714153 718581 723377 726332 726503 726589 727513 727818 727898 728452 729209 730076 731752 731754 731756 731796 731832 732258 740185 741904 748130 748151 748225 748232 765299 775571 781019 781485 788877 789527 790983 792822 794629 794651 798905 803918 807376 808040 808263 808690 810061 811013 815940 817208 817597 818206 819823 820384 820683 824021 824604 824621 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature lick girl"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature лиза девушк"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"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.