Query Metrics
7
Database Queries
7
Different statements
144.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.13 ms (84.60%) |
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 70131 191315 381752 385386 388179 396887 398544 401638 411817 458126 460724 462315 466885 469453 480077 485700 488311 491790 498217 516053 518911 525481 533459 534580 537484 546132 546137 546138 546141 546145 551926 554350 554352 557171 558657 563779 563960 578823 593023 614378 622527 624466 624469 636438 636557 663901 677971 678779 681609 682414 696729 698765 701444 704265 705054 705058 705069 717121 719900 722434 726271 727915 729781 730118 731193 731445 732986 733497 733946 734173 734270 736000 738296 738314 738316 738331 738333 738342 738343 738350 738358 739686 743967 744223 744363 745252 747070 748017 749232 770121 770201 772881 772885 773884 780663 780682 780691 781754 788822 788981 794743 796016 796019 796028 799358 802326 802966 804057 804130 804590 807603 817544 817689 823770 825038 825140 825461 826990 827278 827308 ] |
||||||||||||||||||||||||||||||
|
10.78 ms (7.47%) |
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 826990 518911 537484 563779 546137 554350 546141 624466 781754 773884 799358 743967 770201 731193 719900 796028 802326 705058 748017 736000 491790 678779 462315 381752 485700 705069 533459 498217 546145 557171 636438 624469 796019 738358 458126 705054 738350 70131 191315 396887 398544 823770 817689 825038 825461 460724 558657 701444 677971 682414 722434 796016 738342 804130 747070 734270 772885 730118 731445 734173 717121 788981 794743 411817 578823 802966 772881 807603 738343 744223 704265 466885 516053 480077 546138 546132 681609 727915 733946 732986 738314 739686 388179 401638 817544 827278 827308 825140 525481 534580 563960 663901 696729 593023 614378 780663 780682 780691 788822 726271 738331 749232 770121 745252 698765 744363 804590 804057 469453 488311 551926 622527 729781 733497 738333 738296 738316 636557 385386 554352 ] |
||||||||||||||||||||||||||||||
|
3.64 ms (2.52%) |
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 70131 191315 381752 385386 388179 396887 398544 401638 411817 458126 460724 462315 466885 469453 480077 485700 488311 491790 498217 516053 518911 525481 533459 534580 537484 546132 546137 546138 546141 546145 551926 554350 554352 557171 558657 563779 563960 578823 593023 614378 622527 624466 624469 636438 636557 663901 677971 678779 681609 682414 696729 698765 701444 704265 705054 705058 705069 717121 719900 722434 726271 727915 729781 730118 731193 731445 732986 733497 733946 734173 734270 736000 738296 738314 738316 738331 738333 738342 738343 738350 738358 739686 743967 744223 744363 745252 747070 748017 749232 770121 770201 772881 772885 773884 780663 780682 780691 781754 788822 788981 794743 796016 796019 796028 799358 802326 802966 804057 804130 804590 807603 817544 817689 823770 825038 825140 825461 826990 827278 827308 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сперма у старушки"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм бабушк"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм бабушк"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.23%) |
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.