Query Metrics
7
Database Queries
7
Different statements
162.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.29 ms (81.78%) |
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 156525 384901 386883 395839 396990 401533 403240 403404 404652 406592 431015 437494 446718 456497 481591 486301 495652 516347 525622 541919 557158 590858 590907 592373 612038 612812 615538 617185 617193 622360 629362 632014 672579 675923 675936 675953 676283 676354 676777 676851 676889 676890 678313 679462 696047 702446 702687 704930 709260 711337 712047 721187 723986 724328 724333 731086 737099 737168 746100 748985 750326 752566 758617 759667 770520 770524 770670 771821 772970 776307 776396 776566 777064 789712 790001 793427 795525 800210 800274 805181 805374 805563 805876 806649 810599 810902 811539 811867 812790 813652 814268 815316 815379 815830 815988 816561 817320 817669 817917 817935 818221 818282 818386 818457 818471 820336 820353 820387 820512 820743 821201 821216 821352 821583 822222 822645 822832 822960 823411 825073 ] |
||||||||||||||||||||||||||||||
|
17.85 ms (10.95%) |
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 156525 676889 790001 815830 821583 704930 810599 401533 811867 806649 800210 820512 821216 825073 789712 748985 724333 731086 811539 404652 431015 810902 486301 676354 812790 516347 818221 592373 709260 446718 815379 820336 702687 456497 406592 813652 816561 814268 712047 737099 617185 793427 676777 437494 525622 815316 590907 750326 770670 772970 702446 805563 676283 495652 675936 818471 822960 822645 823411 675953 820743 818457 622360 481591 711337 776396 384901 721187 632014 724328 771821 817917 676851 776566 723986 541919 821352 612812 758617 759667 676890 395839 386883 795525 805876 821201 820387 817320 817669 678313 615538 770524 752566 746100 612038 776307 403240 822222 822832 815988 557158 679462 672579 675923 696047 590858 617193 777064 800274 805374 737168 770520 629362 805181 403404 396990 818386 820353 817935 818282 ] |
||||||||||||||||||||||||||||||
|
4.15 ms (2.54%) |
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 156525 384901 386883 395839 396990 401533 403240 403404 404652 406592 431015 437494 446718 456497 481591 486301 495652 516347 525622 541919 557158 590858 590907 592373 612038 612812 615538 617185 617193 622360 629362 632014 672579 675923 675936 675953 676283 676354 676777 676851 676889 676890 678313 679462 696047 702446 702687 704930 709260 711337 712047 721187 723986 724328 724333 731086 737099 737168 746100 748985 750326 752566 758617 759667 770520 770524 770670 771821 772970 776307 776396 776566 777064 789712 790001 793427 795525 800210 800274 805181 805374 805563 805876 806649 810599 810902 811539 811867 812790 813652 814268 815316 815379 815830 815988 816561 817320 817669 817917 817935 818221 818282 818386 818457 818471 820336 820353 820387 820512 820743 821201 821216 821352 821583 822222 822645 822832 822960 823411 825073 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina threesome"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.