Query Metrics
7
Database Queries
7
Different statements
155.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.74 ms (85.30%) |
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 385928 388094 390994 392990 395710 396352 396507 402969 402997 406059 406981 407357 407878 408585 410867 411197 411727 411938 413446 416992 420417 421003 422176 423863 426132 443941 446131 446706 448818 449608 449889 454999 455462 455718 462260 462714 465331 475892 482718 483816 490088 492725 503943 508695 509205 511333 512230 517673 519136 520254 521469 522079 527246 528006 533012 533051 535920 537840 539220 544961 545771 556654 556839 557749 560577 564717 565316 565375 569330 591909 596673 601569 602947 606897 622189 623443 628414 631170 631970 634337 644973 645283 665789 673658 686627 692143 693554 696160 696663 697507 709748 714047 729565 744965 752869 760920 761840 767175 767965 778130 778894 780646 781859 782925 788293 791352 793749 801421 802163 802829 803332 805159 807359 810402 810477 810972 814103 818123 825721 827838 ] |
||||||||||||||||||||||||||||||
|
13.72 ms (8.81%) |
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 390994 591909 407357 443941 645283 622189 744965 631170 416992 407878 454999 533051 556839 421003 410867 462260 537840 560577 462714 535920 392990 517673 818123 413446 527246 544961 788293 761840 503943 446131 565316 601569 628414 396352 509205 521469 402997 825721 827838 545771 696663 686627 634337 780646 511333 519136 508695 411727 692143 802163 752869 767965 606897 778130 426132 446706 533012 475892 520254 693554 596673 623443 781859 793749 778894 802829 810402 729565 767175 385928 492725 522079 539220 665789 402969 422176 709748 406981 490088 423863 696160 411938 556654 448818 465331 449889 569330 455718 512230 644973 406059 803332 395710 388094 697507 810972 482718 408585 455462 782925 564717 528006 396507 411197 420417 814103 449608 483816 565375 557749 714047 673658 631970 602947 791352 801421 805159 810477 807359 760920 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (2.02%) |
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 385928 388094 390994 392990 395710 396352 396507 402969 402997 406059 406981 407357 407878 408585 410867 411197 411727 411938 413446 416992 420417 421003 422176 423863 426132 443941 446131 446706 448818 449608 449889 454999 455462 455718 462260 462714 465331 475892 482718 483816 490088 492725 503943 508695 509205 511333 512230 517673 519136 520254 521469 522079 527246 528006 533012 533051 535920 537840 539220 544961 545771 556654 556839 557749 560577 564717 565316 565375 569330 591909 596673 601569 602947 606897 622189 623443 628414 631170 631970 634337 644973 645283 665789 673658 686627 692143 693554 696160 696663 697507 709748 714047 729565 744965 752869 760920 761840 767175 767965 778130 778894 780646 781859 782925 788293 791352 793749 801421 802163 802829 803332 805159 807359 810402 810477 810972 814103 818123 825721 827838 ] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"red head blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рыжая минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рыжая минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.92%) |
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.