Query Metrics
7
Database Queries
7
Different statements
149.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.19 ms (85.08%) |
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 167822 233027 382363 383434 387846 395784 398309 399346 408730 408940 410146 411776 412380 417135 424937 432631 442999 446469 450076 455732 456525 456862 461964 473711 474216 475173 476658 481019 484286 486619 490660 492402 498104 501597 505937 512643 512655 513692 514975 523008 532509 541796 550406 564955 567150 581714 588865 593003 593043 600241 618929 620575 624201 631601 636487 642271 642273 700019 710570 714901 723728 727634 729049 729640 734164 736658 737261 738093 738433 738909 739504 739530 740123 740848 743329 744277 748136 750951 754217 755373 756841 760818 763951 763974 767351 767925 774764 783215 785348 785349 785674 788572 793810 795658 797175 798805 799155 799440 799636 800430 801364 803673 803831 804652 806017 807251 807271 812038 812154 812669 813202 813370 813717 815263 816975 825302 825590 827925 827942 ] |
||||||||||||||||||||||||||||||
|
13.50 ms (9.03%) |
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 631601 642273 642271 600241 618929 636487 793810 797175 799440 801364 803831 812669 774764 785674 788572 800430 804652 806017 813370 727634 736658 737261 740123 740848 750951 756841 785348 785349 798805 799636 803673 734164 738909 767351 767925 723728 739504 739530 754217 755373 760818 763951 729049 729640 738433 743329 744277 763974 738093 748136 700019 710570 714901 783215 795658 799155 807251 807271 812038 812154 813202 387846 475173 408940 383434 395784 474216 233027 498104 501597 505937 512655 512643 442999 417135 816975 581714 456525 484286 486619 523008 532509 513692 564955 541796 567150 550406 588865 593003 593043 620575 461964 514975 624201 167822 382363 398309 399346 432631 410146 408730 411776 412380 424937 825590 825302 813717 815263 821926 827925 827942 450076 455732 446469 456862 473711 481019 476658 490660 492402 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.67%) |
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 167822 233027 382363 383434 387846 395784 398309 399346 408730 408940 410146 411776 412380 417135 424937 432631 442999 446469 450076 455732 456525 456862 461964 473711 474216 475173 476658 481019 484286 486619 490660 492402 498104 501597 505937 512643 512655 513692 514975 523008 532509 541796 550406 564955 567150 581714 588865 593003 593043 600241 618929 620575 624201 631601 636487 642271 642273 700019 710570 714901 723728 727634 729049 729640 734164 736658 737261 738093 738433 738909 739504 739530 740123 740848 743329 744277 748136 750951 754217 755373 756841 760818 763951 763974 767351 767925 774764 783215 785348 785349 785674 788572 793810 795658 797175 798805 799155 799440 799636 800430 801364 803673 803831 804652 806017 807251 807271 812038 812154 812669 813202 813370 813717 815263 816975 825302 825590 827925 827942 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy horny"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy horny"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy horny"
]
|
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.