Query Metrics
7
Database Queries
7
Different statements
151.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.63 ms (79.73%) |
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 187996 188335 233889 382184 382444 384279 385974 386997 388862 390303 391565 392031 395998 396941 396969 397223 398563 407727 407782 411385 411708 411773 415559 419146 442649 442869 443378 443925 453096 454230 454559 460172 460759 462328 466136 466147 467240 467830 471053 474485 474491 483374 484395 484417 485689 485755 492001 524476 531546 532697 537135 565116 571144 576478 587805 591877 603358 625036 664846 665408 665415 665513 666770 707476 710268 712215 714164 715475 716487 724232 724284 725135 726756 727499 731137 731755 731772 731836 734015 737897 742595 744207 744906 748163 758118 758444 770100 770151 770259 772119 776742 781679 781897 781980 788518 788520 797254 799968 802798 804112 807376 807546 808003 808434 810769 814125 815340 816784 817360 817810 818449 818737 819241 819637 819646 826127 826246 826555 827583 ] |
||||||||||||||||||||||||||||||
|
18.58 ms (12.28%) |
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 748163 724232 737897 742595 625036 781980 810769 443378 492001 665408 808434 772119 715475 484395 817360 397223 442649 819637 819646 826555 818737 826127 531546 537135 716487 665513 664846 666770 587805 776742 802798 788520 808003 731137 758444 781897 726756 731772 734015 744207 731836 770151 731755 744906 781679 788518 797254 799968 385974 388862 411773 807376 411385 233889 565116 817810 828044 187996 819241 532697 571144 591877 725135 758118 727499 712215 460759 471053 474485 466147 442869 710268 724284 804112 770100 396969 603358 467830 453096 807546 390303 391565 415559 460172 384279 396941 188335 814125 818449 827583 815340 524476 576478 770259 714164 382184 382444 411708 419146 485689 483374 665415 707476 454230 462328 467240 454559 443925 474491 466136 484417 485755 395998 386997 398563 407727 816784 826246 407782 392031 ] |
||||||||||||||||||||||||||||||
|
3.38 ms (2.23%) |
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 187996 188335 233889 382184 382444 384279 385974 386997 388862 390303 391565 392031 395998 396941 396969 397223 398563 407727 407782 411385 411708 411773 415559 419146 442649 442869 443378 443925 453096 454230 454559 460172 460759 462328 466136 466147 467240 467830 471053 474485 474491 483374 484395 484417 485689 485755 492001 524476 531546 532697 537135 565116 571144 576478 587805 591877 603358 625036 664846 665408 665415 665513 666770 707476 710268 712215 714164 715475 716487 724232 724284 725135 726756 727499 731137 731755 731772 731836 734015 737897 742595 744207 744906 748163 758118 758444 770100 770151 770259 772119 776742 781679 781897 781980 788518 788520 797254 799968 802798 804112 807376 807546 808003 808434 810769 814125 815340 816784 817360 817810 818449 818737 819241 819637 819646 826127 826246 826555 827583 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.62%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature boobs сиськ"
]
|
||||||||||||||||||||||||||||||
|
2.40 ms (1.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature boobs tits"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature boobs сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.23%) |
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.