Query Metrics
7
Database Queries
7
Different statements
138.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
114.51 ms (82.62%) |
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 907 162863 163116 185352 257723 322773 381767 382874 384493 385471 385905 386555 388417 390970 401414 401507 406334 406501 420045 420211 420231 422568 423063 424918 429276 431497 431607 432317 433299 446244 456637 460959 462288 469800 469803 492411 510168 511266 512220 521230 525103 540201 540213 542642 546292 550732 550739 551949 551972 552897 552928 554094 554157 557237 557821 559159 559162 559853 559882 566001 572730 572738 574467 574642 588390 590747 595705 600564 604009 604086 608009 610650 619438 619448 622615 622639 634866 636883 644912 645662 652252 662078 673050 673137 674352 674469 689688 697447 702445 702497 711841 712166 713113 718677 721756 722803 724460 724480 727853 730556 731576 740831 741106 742486 742925 743069 755824 757563 758905 763181 766781 784466 784609 790918 793657 799871 802831 815015 817179 828638 ] |
||||||||||||||||||||||||||||||
|
14.35 ms (10.35%) |
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 433299 423063 644912 540201 540213 511266 542642 550732 673137 662078 673050 546292 604009 622639 799871 763181 784609 802831 757563 727853 741106 758905 322773 163116 385471 429276 456637 446244 512220 521230 574642 551972 574467 551949 552897 572738 608009 420231 384493 381767 431497 815015 492411 525103 572730 554094 559853 652252 674352 674469 702445 712166 645662 711841 588390 590747 600564 610650 619448 634866 622615 784466 790918 724480 740831 766781 724460 721756 559159 401414 469800 469803 554157 566001 424918 462288 422568 406501 552928 828638 390970 559162 257723 697447 382874 185352 420045 718677 619438 743069 731576 755824 730556 742925 742486 401507 907 388417 386555 406334 431607 460959 510168 550739 557237 559882 689688 702497 713113 722803 557821 595705 636883 604086 793657 162863 385905 817179 420211 432317 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.96%) |
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 907 162863 163116 185352 257723 322773 381767 382874 384493 385471 385905 386555 388417 390970 401414 401507 406334 406501 420045 420211 420231 422568 423063 424918 429276 431497 431607 432317 433299 446244 456637 460959 462288 469800 469803 492411 510168 511266 512220 521230 525103 540201 540213 542642 546292 550732 550739 551949 551972 552897 552928 554094 554157 557237 557821 559159 559162 559853 559882 566001 572730 572738 574467 574642 588390 590747 595705 600564 604009 604086 608009 610650 619438 619448 622615 622639 634866 636883 644912 645662 652252 662078 673050 673137 674352 674469 689688 697447 702445 702497 711841 712166 713113 718677 721756 722803 724460 724480 727853 730556 731576 740831 741106 742486 742925 743069 755824 757563 758905 763181 766781 784466 784609 790918 793657 799871 802831 815015 817179 828638 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian sex"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк секс"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.09%) |
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.