Query Metrics
7
Database Queries
7
Different statements
145.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.39 ms (82.55%) |
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 4377 8824 78942 80203 117844 366004 383598 385035 385841 387541 389060 391155 391596 392181 392547 393621 394498 394586 395450 396432 396794 396834 397113 399806 401599 402596 407165 409702 413335 415344 416299 418443 420368 423459 423600 424209 424612 426272 427233 427911 428100 429567 437845 437901 441424 442649 443905 450126 453659 455997 457408 458608 459083 460545 464954 465459 476635 477386 477565 479088 482944 484304 485029 485343 488520 494682 496194 498317 505947 518806 521533 523136 543596 550519 551602 559672 564998 578797 583859 590612 597171 601229 603668 609707 613898 620249 621777 623395 630725 641134 661920 666466 680436 684693 686384 692280 695080 700476 700824 701661 721484 727507 732579 732792 738121 751508 758337 760509 761916 768041 779895 791248 791881 792308 792653 792746 803873 809790 810136 811710 ] |
||||||||||||||||||||||||||||||
|
15.34 ms (10.52%) |
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 613898 803873 666466 543596 590612 396432 518806 485343 385035 117844 8824 441424 420368 551602 760509 809790 738121 701661 792746 415344 428100 641134 680436 488520 484304 661920 684693 686384 692280 695080 721484 761916 700476 393621 482944 791881 768041 792653 383598 80203 395450 387541 429567 409702 450126 621777 791248 399806 424209 459083 496194 620249 700824 603668 477565 597171 423600 426272 427911 78942 396794 397113 416299 442649 443905 407165 455997 505947 583859 550519 751508 758337 401599 477386 453659 4377 779895 389060 402596 413335 418443 460545 465459 476635 811710 732792 394498 521533 458608 609707 437901 392547 427233 423459 485029 564998 623395 727507 792308 810136 396834 391155 424612 366004 498317 437845 392181 457408 494682 601229 523136 385841 559672 732579 630725 578797 394586 391596 464954 479088 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (2.00%) |
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 4377 8824 78942 80203 117844 366004 383598 385035 385841 387541 389060 391155 391596 392181 392547 393621 394498 394586 395450 396432 396794 396834 397113 399806 401599 402596 407165 409702 413335 415344 416299 418443 420368 423459 423600 424209 424612 426272 427233 427911 428100 429567 437845 437901 441424 442649 443905 450126 453659 455997 457408 458608 459083 460545 464954 465459 476635 477386 477565 479088 482944 484304 485029 485343 488520 494682 496194 498317 505947 518806 521533 523136 543596 550519 551602 559672 564998 578797 583859 590612 597171 601229 603668 609707 613898 620249 621777 623395 630725 641134 661920 666466 680436 684693 686384 692280 695080 700476 700824 701661 721484 727507 732579 732792 738121 751508 758337 760509 761916 768041 779895 791248 791881 792308 792653 792746 803873 809790 810136 811710 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"муж трахает любовникÐ%…"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен секс любовник"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.10%) |
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.