Query Metrics
7
Database Queries
7
Different statements
595.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
425.78 ms (71.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"guy pussy лиза"
]
|
||||||||||||||||||||||||||||||
|
141.93 ms (23.81%) |
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 102026 191348 313286 382094 384940 386658 388979 390345 391581 401509 402095 404490 408472 437870 443671 446285 449273 449301 450400 451090 452376 454680 456611 458416 460507 461041 461124 462501 466235 469753 474379 477387 477397 477678 477884 480523 483394 486619 489166 491796 505397 508823 511690 513311 517101 518831 525938 527570 531185 532509 535100 542469 542783 546934 554390 554498 557271 557307 560394 563135 564163 564429 564704 567150 567433 569988 573475 579200 583247 590348 596193 596507 600314 601653 604813 608352 611754 630215 645194 649608 663268 666465 669456 673048 676510 688003 691127 703212 708762 714082 715397 715578 719279 721461 723112 723504 724203 725165 729883 737070 737079 737500 741091 741307 741904 744441 758295 781648 781704 785791 788722 790640 793175 796540 799391 808775 815739 815830 818779 820715 ] |
||||||||||||||||||||||||||||||
|
19.32 ms (3.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 404490 815830 815739 451090 527570 564704 554498 663268 676510 721461 649608 666465 708762 719279 723112 563135 600314 611754 608352 596507 799391 788722 758295 729883 741904 737079 741091 723504 785791 446285 460507 391581 525938 508823 518831 450400 449273 511690 703212 480523 469753 452376 474379 408472 820715 531185 535100 557271 564163 673048 645194 715397 669456 691127 715578 557307 630215 590348 604813 781704 796540 790640 808775 724203 737500 741307 744441 725165 737070 781648 402095 401509 462501 443671 483394 456611 579200 583247 569988 688003 601653 596193 793175 477884 466235 517101 491796 486619 532509 564429 573475 567150 714082 554390 386658 384940 102026 191348 313286 382094 388979 390345 437870 818779 449301 458416 477678 454680 461041 461124 477397 489166 505397 513311 477387 546934 560394 567433 542469 542783 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (0.44%) |
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 102026 191348 313286 382094 384940 386658 388979 390345 391581 401509 402095 404490 408472 437870 443671 446285 449273 449301 450400 451090 452376 454680 456611 458416 460507 461041 461124 462501 466235 469753 474379 477387 477397 477678 477884 480523 483394 486619 489166 491796 505397 508823 511690 513311 517101 518831 525938 527570 531185 532509 535100 542469 542783 546934 554390 554498 557271 557307 560394 563135 564163 564429 564704 567150 567433 569988 573475 579200 583247 590348 596193 596507 600314 601653 604813 608352 611754 630215 645194 649608 663268 666465 669456 673048 676510 688003 691127 703212 708762 714082 715397 715578 719279 721461 723112 723504 724203 725165 729883 737070 737079 737500 741091 741307 741904 744441 758295 781648 781704 785791 788722 790640 793175 796540 799391 808775 815739 815830 818779 820715 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"guy pussy licking"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (0.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"guy pussy лиза"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (0.35%) |
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.