Query Metrics
7
Database Queries
7
Different statements
157.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.96 ms (82.63%) |
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 392990 395922 398364 401899 421426 421855 421866 421875 422237 423909 424047 429362 436490 439809 442231 442947 444115 445178 445493 448227 451634 456308 458069 460109 462108 462536 463634 466201 468163 468670 470599 470708 472302 475017 475234 475614 478519 480353 483369 483647 484277 487156 487163 487620 490695 493006 494442 494598 497573 497909 499746 500518 500983 501905 502648 504299 505579 505966 506179 506448 510743 511289 515994 516483 520081 520304 523428 523441 523514 523691 525984 527832 527853 528660 543310 543820 547035 547835 548158 549560 552804 552811 553954 556726 560318 560894 563776 566751 567372 568214 569788 570086 570873 577513 577997 581503 582566 584159 584795 587097 599504 619097 623404 631961 643817 656891 659370 675866 690936 736830 738435 744966 745804 764627 766830 775466 791731 793295 811093 811879 ] |
||||||||||||||||||||||||||||||
|
17.56 ms (11.17%) |
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 445493 569788 442947 568214 570873 577513 587097 793295 421866 458069 504299 487620 484277 527853 506179 738435 775466 631961 505579 497909 552804 566751 811879 745804 764627 811093 475614 470708 478519 501905 494598 499746 523514 483647 424047 472302 659370 520081 581503 392990 401899 511289 525984 421875 516483 582566 502648 460109 506448 395922 475017 556726 643817 463634 444115 500983 549560 439809 470599 494442 429362 560318 675866 599504 422237 421855 487163 497573 423909 421426 553954 577997 791731 451634 445178 462536 448227 475234 466201 500518 527832 398364 480353 656891 736830 468163 462108 515994 584159 493006 487156 468670 456308 543820 552811 548158 510743 528660 523691 623404 619097 483369 523428 442231 523441 570086 520304 547035 584795 563776 560894 744966 766830 690936 505966 436490 490695 543310 567372 547835 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.61%) |
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 392990 395922 398364 401899 421426 421855 421866 421875 422237 423909 424047 429362 436490 439809 442231 442947 444115 445178 445493 448227 451634 456308 458069 460109 462108 462536 463634 466201 468163 468670 470599 470708 472302 475017 475234 475614 478519 480353 483369 483647 484277 487156 487163 487620 490695 493006 494442 494598 497573 497909 499746 500518 500983 501905 502648 504299 505579 505966 506179 506448 510743 511289 515994 516483 520081 520304 523428 523441 523514 523691 525984 527832 527853 528660 543310 543820 547035 547835 548158 549560 552804 552811 553954 556726 560318 560894 563776 566751 567372 568214 569788 570086 570873 577513 577997 581503 582566 584159 584795 587097 599504 619097 623404 631961 643817 656891 659370 675866 690936 736830 738435 744966 745804 764627 766830 775466 791731 793295 811093 811879 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"домашний секс рыжая"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск секс рыжая"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск секс рыжая"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.09%) |
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.