Query Metrics
7
Database Queries
7
Different statements
197.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.89 ms (84.51%) |
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 36832 419520 428833 448958 456847 467336 470920 523680 526706 529284 542957 551017 554531 563421 564787 590285 600384 602859 606698 607306 610315 620299 620557 621337 622198 622622 622826 623598 624255 626330 626733 631952 631980 645891 648877 656317 663321 667525 677027 681039 681699 686073 688034 688083 689328 706912 709841 714053 714441 715402 716078 720441 720786 720819 726625 727638 727642 728018 730324 732308 732423 735418 736425 737445 742811 744279 745999 747258 748151 748240 748982 750465 754205 755854 759570 765299 766536 770111 770179 770217 770280 774158 775385 776022 785426 786254 788507 790983 796555 798939 800868 803252 803336 806311 807334 807493 807495 807546 807968 808167 808511 808917 810908 812020 812151 812510 814143 815248 815981 817398 818282 818403 818462 820047 820346 820766 820986 821612 823173 826592 ] |
||||||||||||||||||||||||||||||
|
19.25 ms (9.75%) |
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 823173 826592 814143 815248 815981 820047 821612 817398 818282 820346 820986 818403 818462 820766 448958 456847 526706 529284 523680 542957 551017 554531 563421 564787 663321 667525 681039 686073 689328 706912 645891 656317 677027 681699 714053 714441 715402 720786 648877 688034 688083 716078 720441 720819 590285 607306 622826 626733 606698 620299 621337 626330 631952 631980 610315 600384 602859 620557 622198 622622 788507 790983 808511 796555 803252 803336 807334 812151 727642 737445 748982 755854 770179 786254 807546 807968 810908 812510 727638 736425 748151 766536 774158 745999 747258 754205 730324 732308 732423 735418 744279 759570 770111 770217 726625 728018 742811 748240 750465 765299 770280 623598 624255 709841 775385 776022 785426 798939 800868 806311 807493 807495 808167 808917 812020 428833 470920 36832 419520 467336 ] |
||||||||||||||||||||||||||||||
|
4.29 ms (2.17%) |
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 36832 419520 428833 448958 456847 467336 470920 523680 526706 529284 542957 551017 554531 563421 564787 590285 600384 602859 606698 607306 610315 620299 620557 621337 622198 622622 622826 623598 624255 626330 626733 631952 631980 645891 648877 656317 663321 667525 677027 681039 681699 686073 688034 688083 689328 706912 709841 714053 714441 715402 716078 720441 720786 720819 726625 727638 727642 728018 730324 732308 732423 735418 736425 737445 742811 744279 745999 747258 748151 748240 748982 750465 754205 755854 759570 765299 766536 770111 770179 770217 770280 774158 775385 776022 785426 786254 788507 790983 796555 798939 800868 803252 803336 806311 807334 807493 807495 807546 807968 808167 808511 808917 810908 812020 812151 812510 814143 815248 815981 817398 818282 818403 818462 820047 820346 820766 820986 821612 823173 826592 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old лиза pussy"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old lick pussy"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old лиза pussy"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.82%) |
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.