Query Metrics
7
Database Queries
7
Different statements
157.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.67 ms (84.44%) |
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 154451 385390 391992 416523 416580 416583 416597 416611 416632 416659 416668 416670 416712 416733 419167 423435 443260 443432 444283 444896 444967 448351 449377 449930 452800 458504 458678 466633 466639 467579 468943 470479 471074 471682 476847 477761 483730 488820 493443 495467 497691 497697 498318 500338 506063 506268 511953 512442 514233 521682 522169 526943 530423 532803 534546 538309 540531 541541 542142 545395 545445 545455 547470 547486 547659 550550 557720 576479 583689 584362 584999 590803 597190 597691 598141 598540 598882 614967 624197 625780 641997 642058 648710 648869 655011 660364 660367 662448 662813 669035 669057 671045 672939 673257 678707 679974 696594 696596 713142 722388 722395 728567 739131 739145 740409 742359 745088 751546 752634 752670 754902 766415 785606 790154 797003 799693 808998 810501 811696 814459 ] |
||||||||||||||||||||||||||||||
|
15.00 ms (9.54%) |
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 416611 416659 419167 416597 470479 471074 448351 512442 545455 547486 550550 672939 722395 648869 713142 669035 669057 671045 597691 597190 598141 641997 799693 808998 766415 739131 739145 751546 468943 416523 416668 423435 498318 154451 598882 416712 443260 444283 452800 483730 500338 514233 557720 662448 598540 391992 477761 444967 814459 458504 467579 449377 471682 530423 532803 534546 526943 540531 576479 541541 542142 545395 547659 648710 660367 660364 678707 696594 662813 673257 696596 624197 642058 614967 810501 811696 790154 797003 785606 728567 740409 745088 742359 752634 752670 754902 722388 506268 416632 416733 584999 476847 449930 493443 538309 511953 497691 497697 522169 466633 583689 547470 545445 584362 590803 466639 495467 506063 521682 488820 655011 679974 444896 625780 385390 416583 416580 416670 443432 458678 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.75%) |
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 154451 385390 391992 416523 416580 416583 416597 416611 416632 416659 416668 416670 416712 416733 419167 423435 443260 443432 444283 444896 444967 448351 449377 449930 452800 458504 458678 466633 466639 467579 468943 470479 471074 471682 476847 477761 483730 488820 493443 495467 497691 497697 498318 500338 506063 506268 511953 512442 514233 521682 522169 526943 530423 532803 534546 538309 540531 541541 542142 545395 545445 545455 547470 547486 547659 550550 557720 576479 583689 584362 584999 590803 597190 597691 598141 598540 598882 614967 624197 625780 641997 642058 648710 648869 655011 660364 660367 662448 662813 669035 669057 671045 672939 673257 678707 679974 696594 696596 713142 722388 722395 728567 739131 739145 740409 742359 745088 751546 752634 752670 754902 766415 785606 790154 797003 799693 808998 810501 811696 814459 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge dildo riding"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные дилд riding"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные дилд riding"
]
|
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.