Query Metrics
7
Database Queries
7
Different statements
180.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.49 ms (84.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 400494 410995 412662 413592 424377 428100 433323 436207 439609 439675 439686 439723 441442 441447 441448 441462 441501 442195 442204 442332 442933 443351 444637 445323 445786 445872 446054 449222 449845 450785 451171 452500 453508 453557 454501 455211 455983 457034 457442 457683 459317 459412 459656 460479 464936 465142 465927 467721 467910 472113 473194 474003 475897 479954 480024 482454 485273 487572 488776 496851 497179 497834 501425 504772 513029 515440 518477 519496 519715 520189 520364 520428 520623 520888 521820 524136 524188 525092 527000 527655 527886 528306 528343 528355 529811 531508 536414 542754 549839 552348 556241 556665 558266 564850 565665 569831 570748 574667 575716 581996 582382 593540 593541 595730 595834 602928 603604 604092 604746 605162 612507 616778 620057 632818 635187 672769 674971 759488 775958 805224 ] |
||||||||||||||||||||||||||||||
|
18.48 ms (10.24%) |
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 443351 459317 410995 449222 479954 455211 520888 488776 497179 525092 441442 441462 445872 593540 595834 805224 632818 465927 473194 524136 496851 501425 519496 604746 442204 529811 520189 604092 442195 497834 518477 519715 487572 455983 467910 582382 444637 459656 531508 570748 593541 595730 612507 527655 524188 474003 464936 635187 400494 457442 445323 412662 520623 449845 465142 574667 759488 475897 439675 439609 527886 428100 521820 528306 552348 672769 564850 620057 453508 472113 436207 515440 504772 441447 441448 457683 556241 605162 413592 513029 450785 457034 775958 520428 528343 446054 520364 452500 451171 536414 485273 569831 542754 549839 616778 442933 528355 482454 459412 480024 674971 556665 558266 424377 441501 453557 603604 467721 442332 445786 439686 433323 439723 527000 575716 454501 460479 581996 565665 602928 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.60%) |
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 400494 410995 412662 413592 424377 428100 433323 436207 439609 439675 439686 439723 441442 441447 441448 441462 441501 442195 442204 442332 442933 443351 444637 445323 445786 445872 446054 449222 449845 450785 451171 452500 453508 453557 454501 455211 455983 457034 457442 457683 459317 459412 459656 460479 464936 465142 465927 467721 467910 472113 473194 474003 475897 479954 480024 482454 485273 487572 488776 496851 497179 497834 501425 504772 513029 515440 518477 519496 519715 520189 520364 520428 520623 520888 521820 524136 524188 525092 527000 527655 527886 528306 528343 528355 529811 531508 536414 542754 549839 552348 556241 556665 558266 564850 565665 569831 570748 574667 575716 581996 582382 593540 593541 595730 595834 602928 603604 604092 604746 605162 612507 616778 620057 632818 635187 672769 674971 759488 775958 805224 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"made sex"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"made секс"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"made секс"
]
|
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.