Query Metrics
7
Database Queries
7
Different statements
198.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.95 ms (87.04%) |
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 385884 395285 413098 415303 420295 427364 428174 430366 439796 441355 443340 445945 450020 450557 455365 458115 459563 467560 471110 483315 483537 483583 488179 490587 493839 497778 500288 505902 508891 513450 514339 518087 519349 520953 521842 523640 527922 546384 546762 553215 554680 554695 556745 558521 559281 559784 559787 561905 564856 581759 582848 584843 586002 589604 613780 615283 631301 638045 639109 642240 654992 659341 666672 689010 689762 699963 702338 703586 725742 727277 736903 738469 738479 742303 752440 755006 758664 761246 770811 777272 777771 780268 780314 780352 780412 782050 782092 782100 782656 783168 787238 787627 790414 790422 791884 791888 791890 793092 795405 803126 803510 803549 805394 807242 808125 811573 816131 819256 820802 821554 821593 821808 823372 823884 824417 824531 824837 826941 827389 827392 ] |
||||||||||||||||||||||||||||||
|
15.92 ms (8.01%) |
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 505902 520953 497778 514339 518087 523640 395285 819256 821554 823884 824531 824837 490587 513450 581759 584843 558521 554680 780352 755006 471110 488179 824417 823372 654992 659341 699963 689762 546384 554695 556745 615283 638045 589604 639109 642240 777272 777771 780314 780412 782050 790414 791890 782100 782656 791888 795405 805394 807242 736903 752440 761246 782092 787238 793092 808125 811573 758664 770811 738469 738479 725742 727277 783168 790422 791884 803126 803510 689010 803549 742303 631301 420295 445945 508891 559787 586002 430366 821808 483537 521842 703586 702338 780268 787627 413098 459563 450020 455365 500288 415303 441355 450557 458115 483583 519349 527922 546762 559784 559281 582848 666672 553215 561905 564856 613780 443340 467560 427364 493839 483315 428174 439796 385884 816131 821593 826941 827389 827392 820802 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.43%) |
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 385884 395285 413098 415303 420295 427364 428174 430366 439796 441355 443340 445945 450020 450557 455365 458115 459563 467560 471110 483315 483537 483583 488179 490587 493839 497778 500288 505902 508891 513450 514339 518087 519349 520953 521842 523640 527922 546384 546762 553215 554680 554695 556745 558521 559281 559784 559787 561905 564856 581759 582848 584843 586002 589604 613780 615283 631301 638045 639109 642240 654992 659341 666672 689010 689762 699963 702338 703586 725742 727277 736903 738469 738479 742303 752440 755006 758664 761246 770811 777272 777771 780268 780314 780352 780412 782050 782092 782100 782656 783168 787238 787627 790414 790422 791884 791888 791890 793092 795405 803126 803510 803549 805394 807242 808125 811573 816131 819256 820802 821554 821593 821808 823372 823884 824417 824531 824837 826941 827389 827392 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo dildo pussy"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло дилд pussy"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло дилд pussy"
]
|
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.