Query Metrics
7
Database Queries
7
Different statements
144.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.76 ms (85.39%) |
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 69876 86358 204834 279273 308832 323393 334299 372986 383239 384562 385794 390856 396342 396357 407339 409352 413245 419214 453090 472735 525528 534482 542441 551926 557146 557157 566612 567993 580844 588472 589669 599843 616525 621823 626173 627114 629938 631166 634862 636506 644307 648001 650478 651000 661622 669197 674672 674738 682149 685876 692126 694389 698440 707626 709481 713271 714145 714286 715848 716482 716588 718899 719355 724231 724741 728761 729642 731428 731490 732124 741045 744658 746311 747420 749710 755041 757925 760120 768370 769568 769660 771325 772805 773316 775571 776269 776596 779319 779461 779855 781468 788398 790195 793426 793453 794838 796548 796832 799243 799500 799549 799568 801801 803008 803272 804538 805813 806532 807630 810251 812473 815614 815836 818743 818745 821677 821986 822016 822913 ] |
||||||||||||||||||||||||||||||
|
11.34 ms (7.83%) |
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 818745 818743 803008 805813 807630 776269 781468 419214 453090 580844 718899 627114 796832 719355 731428 744658 796548 714145 775571 779461 770409 741045 799549 821677 566612 674738 692126 713271 682149 715848 669197 621823 760120 755041 629938 396342 769660 661622 385794 204834 334299 557146 716482 86358 793453 810251 801801 599843 567993 323393 413245 472735 636506 779855 779319 799500 806532 746311 772805 773316 776596 803272 551926 799243 407339 815836 542441 648001 650478 716588 749710 768370 747420 644307 372986 383239 714286 588472 804538 790195 812473 728761 731490 698440 793426 384562 390856 616525 626173 634862 757925 557157 631166 396357 279273 308832 534482 732124 794838 409352 822913 589669 724231 769568 821986 724741 729642 709481 674672 525528 788398 69876 685876 771325 799568 815614 822016 694389 707626 651000 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.80%) |
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 69876 86358 204834 279273 308832 323393 334299 372986 383239 384562 385794 390856 396342 396357 407339 409352 413245 419214 453090 472735 525528 534482 542441 551926 557146 557157 566612 567993 580844 588472 589669 599843 616525 621823 626173 627114 629938 631166 634862 636506 644307 648001 650478 651000 661622 669197 674672 674738 682149 685876 692126 694389 698440 707626 709481 713271 714145 714286 715848 716482 716588 718899 719355 724231 724741 728761 729642 731428 731490 732124 741045 744658 746311 747420 749710 755041 757925 760120 768370 769568 769660 771325 772805 773316 775571 776269 776596 779319 779461 779855 781468 788398 790195 793426 793453 794838 796548 796832 799243 799500 799549 799568 801801 803008 803272 804538 805813 806532 807630 810251 812473 815614 815836 818743 818745 821677 821986 822016 822913 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex big tits"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.11%) |
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.