Query Metrics
7
Database Queries
7
Different statements
141.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.37 ms (83.91%) |
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 392790 395541 399518 402342 407566 409258 418520 420767 422352 424798 424850 432715 438199 442452 453702 455976 459947 489325 496292 496991 510299 512531 519828 531935 532028 532051 532110 532111 532135 533568 534221 535258 537020 539487 544577 546649 550720 554153 554522 561990 562013 563433 563452 575704 579209 580283 590284 591281 594108 599716 605560 610587 611343 639225 659986 668948 702904 704987 710578 710593 711341 714387 714523 715475 716921 717003 718969 725639 727439 730904 730955 731265 735518 736770 738009 738525 740457 743429 750883 750890 750922 751515 751516 753707 753764 756797 760714 760733 764142 767672 773797 775271 775767 778022 786455 789750 790017 791965 793042 794272 795742 797023 802549 802595 803762 805679 807378 807409 807437 807452 807509 807524 809271 816016 818423 818488 819745 828253 828268 828439 ] |
||||||||||||||||||||||||||||||
|
14.14 ms (10.02%) |
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 807378 750922 750890 735518 760714 764142 750883 605560 714523 807437 420767 399518 579209 753764 793042 496292 816016 532051 562013 580283 544577 668948 710593 753707 795742 802549 392790 532111 819745 828268 828253 828439 590284 775767 736770 409258 818423 550720 519828 716921 594108 775271 730904 743429 738525 773797 756797 639225 711341 704987 424850 786455 402342 438199 418520 533568 534221 702904 563433 715475 489325 751515 407566 532028 422352 459947 453702 531935 539487 778022 455976 432715 424798 659986 610587 809271 575704 537020 510299 807452 818488 730955 532110 512531 532135 561990 710578 554522 591281 599716 803762 789750 790017 395541 442452 496991 535258 546649 714387 717003 718969 554153 563452 611343 807509 807524 791965 794272 807409 760733 802595 740457 725639 727439 767672 731265 738009 751516 797023 805679 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.78%) |
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 392790 395541 399518 402342 407566 409258 418520 420767 422352 424798 424850 432715 438199 442452 453702 455976 459947 489325 496292 496991 510299 512531 519828 531935 532028 532051 532110 532111 532135 533568 534221 535258 537020 539487 544577 546649 550720 554153 554522 561990 562013 563433 563452 575704 579209 580283 590284 591281 594108 599716 605560 610587 611343 639225 659986 668948 702904 704987 710578 710593 711341 714387 714523 715475 716921 717003 718969 725639 727439 730904 730955 731265 735518 736770 738009 738525 740457 743429 750883 750890 750922 751515 751516 753707 753764 756797 760714 760733 764142 767672 773797 775271 775767 778022 786455 789750 790017 791965 793042 794272 795742 797023 802549 802595 803762 805679 807378 807409 807437 807452 807509 807524 809271 816016 818423 818488 819745 828253 828268 828439 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step mom mother"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step mom мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step mom мам женщин"
]
|
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.