Query Metrics
7
Database Queries
7
Different statements
165.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.65 ms (85.56%) |
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 187819 256898 384384 408472 415556 416428 437705 455177 456862 461275 469865 471066 473711 490146 496317 496343 496589 496840 499361 500433 506427 507985 512655 515227 518259 520841 521157 531161 534443 539790 540176 540206 546046 548458 552187 552192 552206 552928 554860 559914 570478 578759 580561 581974 583297 619533 620061 630376 644129 650895 654439 658136 666974 675716 679929 681012 681140 694595 699599 722149 722673 723073 726768 727002 730301 731310 732457 733416 735404 736824 738375 738583 739948 741343 744086 748322 748339 748665 749565 753072 756841 761306 761555 773470 774243 774310 774427 778864 783879 784003 784831 793313 796270 797071 797079 799391 802253 802477 802688 804352 809470 814140 814148 814352 814929 817571 817615 818281 819110 819855 820882 821771 822154 822300 822428 823570 823613 824146 826232 827941 ] |
||||||||||||||||||||||||||||||
|
14.71 ms (8.88%) |
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 819110 774427 822300 818281 822154 824146 827941 471066 500433 540206 496589 515227 534443 552206 552928 554860 552187 581974 583297 679929 694595 723073 681140 546046 570478 620061 619533 802253 783879 793313 744086 748322 730301 741343 749565 739948 774310 726768 732457 735404 761555 773470 731310 733416 738583 753072 630376 722673 778864 796270 797071 797079 804352 256898 187819 507985 817615 823570 823613 819855 820882 826232 821771 469865 490146 496343 521157 531161 548458 578759 580561 650895 658136 666974 681012 699599 675716 722149 654439 552192 559914 644129 799391 802688 809470 748339 756841 802477 738375 774243 727002 736824 761306 784831 461275 384384 416428 518259 512655 814929 520841 784003 748665 408472 415556 437705 814140 814352 817571 822428 814148 455177 456862 473711 496840 539790 496317 499361 506427 540176 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.62%) |
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 187819 256898 384384 408472 415556 416428 437705 455177 456862 461275 469865 471066 473711 490146 496317 496343 496589 496840 499361 500433 506427 507985 512655 515227 518259 520841 521157 531161 534443 539790 540176 540206 546046 548458 552187 552192 552206 552928 554860 559914 570478 578759 580561 581974 583297 619533 620061 630376 644129 650895 654439 658136 666974 675716 679929 681012 681140 694595 699599 722149 722673 723073 726768 727002 730301 731310 732457 733416 735404 736824 738375 738583 739948 741343 744086 748322 748339 748665 749565 753072 756841 761306 761555 773470 774243 774310 774427 778864 783879 784003 784831 793313 796270 797071 797079 799391 802253 802477 802688 804352 809470 814140 814148 814352 814929 817571 817615 818281 819110 819855 820882 821771 822154 822300 822428 823570 823613 824146 826232 827941 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy slut"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy slut"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy slut"
]
|
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.