Query Metrics
7
Database Queries
7
Different statements
229.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
202.92 ms (88.52%) |
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 7308 114756 117755 148814 232978 314552 375949 382043 382353 385832 387328 391493 391600 392347 393672 395929 396057 398064 398545 399083 399354 400382 400684 401085 401309 402666 402682 404185 404216 404554 404953 405029 407378 409021 411561 413264 415200 416707 418690 422420 426703 431314 432723 432789 432796 444733 446002 446534 447537 447667 447690 447879 463943 464177 470511 471115 472110 472773 474021 477596 479009 484051 491776 492109 494384 499936 517038 519573 522020 528938 542604 544421 552398 561649 561858 597798 600314 605850 619800 621287 626597 637690 647983 652247 652882 653211 660444 665714 665865 677345 678586 678620 678981 691915 693103 699631 702629 705791 719214 722585 725409 730751 736394 741531 743232 747147 755592 761092 766777 767198 769904 770441 770911 770925 779135 779711 786327 788897 801475 805941 ] |
||||||||||||||||||||||||||||||
|
15.99 ms (6.98%) |
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 416707 472773 404554 463943 705791 621287 385832 402666 392347 470511 741531 447690 431314 484051 693103 401309 474021 446534 544421 805941 747147 400382 422420 491776 665865 691915 597798 619800 702629 407378 561649 114756 382353 395929 472110 779711 148814 391493 447667 499936 678620 801475 494384 426703 552398 413264 396057 464177 479009 399354 398545 387328 382043 401085 398064 117755 314552 432796 665714 678981 605850 779135 736394 770441 769904 767198 626597 415200 447879 652247 652882 677345 678586 719214 755592 770925 743232 761092 418690 766777 232978 404216 725409 399083 409021 446002 405029 411561 444733 519573 471115 391600 522020 528938 517038 432723 647983 699631 400684 542604 477596 375949 402682 393672 722585 660444 637690 786327 432789 404185 561858 653211 600314 788897 730751 770911 7308 447537 492109 404953 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.35%) |
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 7308 114756 117755 148814 232978 314552 375949 382043 382353 385832 387328 391493 391600 392347 393672 395929 396057 398064 398545 399083 399354 400382 400684 401085 401309 402666 402682 404185 404216 404554 404953 405029 407378 409021 411561 413264 415200 416707 418690 422420 426703 431314 432723 432789 432796 444733 446002 446534 447537 447667 447690 447879 463943 464177 470511 471115 472110 472773 474021 477596 479009 484051 491776 492109 494384 499936 517038 519573 522020 528938 542604 544421 552398 561649 561858 597798 600314 605850 619800 621287 626597 637690 647983 652247 652882 653211 660444 665714 665865 677345 678586 678620 678981 691915 693103 699631 702629 705791 719214 722585 725409 730751 736394 741531 743232 747147 755592 761092 766777 767198 769904 770441 770911 770925 779135 779711 786327 788897 801475 805941 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful blonde anal"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая беловолосая анал"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.70%) |
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.