Query Metrics
7
Database Queries
7
Different statements
200.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.92 ms (85.40%) |
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 73425 187289 191189 233331 266183 384030 386746 387235 388639 391928 397904 405520 412520 415581 420202 421276 425559 426816 427487 428224 434817 441269 441910 442010 442117 442132 443892 447911 447935 453001 454965 456410 457010 460463 462911 462932 464116 464538 464800 465293 465647 465660 467092 468702 469191 469276 472671 473206 473212 477968 478776 479959 481464 482142 482799 483578 483828 484869 486359 487381 487396 488313 490449 494700 495278 495437 495886 496719 498484 498585 499617 506054 510779 512933 513269 513797 514733 516883 517142 517200 521696 522614 525027 525434 529191 529205 530678 531535 532833 532923 533644 534577 535435 535749 536408 536611 537492 541582 543253 545217 554793 555026 555643 559200 559209 569015 574945 576003 579430 598297 630915 644813 650421 686185 787765 813552 814515 815199 818160 818387 ] |
||||||||||||||||||||||||||||||
|
18.21 ms (9.10%) |
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 460463 477968 479959 482142 191189 233331 397904 427487 442132 465647 473206 478776 499617 517200 522614 487381 490449 495886 506054 486359 487396 495278 496719 498585 447911 650421 686185 598297 630915 787765 447935 514733 384030 73425 386746 187289 391928 266183 388639 387235 405520 420202 421276 425559 415581 434817 441269 442010 443892 428224 441910 442117 412520 426816 818160 644813 813552 818387 814515 815199 482799 454965 457010 462932 465660 469191 472671 483828 453001 456410 464538 468702 462911 465293 467092 473212 483578 484869 495437 516883 525434 532923 536408 494700 512933 534577 535749 536611 513269 513797 525027 529205 530678 533644 498484 510779 517142 521696 529191 531535 532833 535435 537492 464116 464800 469276 481464 488313 545217 554793 555026 559200 559209 569015 576003 579430 543253 555643 574945 541582 ] |
||||||||||||||||||||||||||||||
|
4.26 ms (2.13%) |
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 73425 187289 191189 233331 266183 384030 386746 387235 388639 391928 397904 405520 412520 415581 420202 421276 425559 426816 427487 428224 434817 441269 441910 442010 442117 442132 443892 447911 447935 453001 454965 456410 457010 460463 462911 462932 464116 464538 464800 465293 465647 465660 467092 468702 469191 469276 472671 473206 473212 477968 478776 479959 481464 482142 482799 483578 483828 484869 486359 487381 487396 488313 490449 494700 495278 495437 495886 496719 498484 498585 499617 506054 510779 512933 513269 513797 514733 516883 517142 517200 521696 522614 525027 525434 529191 529205 530678 531535 532833 532923 533644 534577 535435 535749 536408 536611 537492 541582 543253 545217 554793 555026 555643 559200 559209 569015 574945 576003 579430 598297 630915 644813 650421 686185 787765 813552 814515 815199 818160 818387 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf slut"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf slut"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.21 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf slut"
]
|
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.