Query Metrics
7
Database Queries
7
Different statements
174.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.71 ms (82.33%) |
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 391926 397656 398354 400023 400689 428177 428305 432735 435386 437999 439475 441113 443170 445711 447789 454535 464705 464837 465172 465252 465923 466591 468348 468393 468438 469760 472324 473784 474737 477597 478073 489014 493610 494438 497507 498751 513219 513394 523541 528315 528380 528489 534432 541727 544976 545366 555170 561008 573270 577912 578298 580595 583597 588014 589472 590802 591259 595459 596738 603313 604338 604421 605437 618908 620259 623303 624484 624578 630289 648393 649516 652683 656498 659387 666374 678909 693897 706359 710418 710510 712553 712770 720099 720126 720174 720417 720664 723131 723153 724614 729090 729299 729962 732262 734324 750317 751424 751433 761189 763515 777003 782602 786178 788079 788852 788911 789075 790126 790542 791885 792171 796132 800896 802049 804309 813861 814457 817273 825876 826934 ] |
||||||||||||||||||||||||||||||
|
19.31 ms (11.06%) |
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 466591 497507 814457 555170 712770 790542 800896 469760 817273 710510 723153 561008 734324 763515 782602 428305 624484 583597 652683 603313 618908 623303 720664 534432 590802 604338 591259 630289 541727 706359 596738 777003 447789 580595 624578 826934 825876 498751 710418 720126 595459 790126 791885 729962 729299 724614 729090 751433 712553 788079 398354 588014 464837 573270 656498 545366 788852 391926 472324 513394 397656 751424 465172 528315 464705 489014 589472 620259 796132 732262 804309 720174 437999 474737 443170 468438 478073 493610 513219 578298 648393 659387 544976 432735 428177 441113 454535 468348 465923 494438 577912 720099 720417 723131 649516 605437 788911 750317 792171 400023 400689 445711 435386 473784 468393 528489 666374 693897 523541 604421 761189 439475 465252 477597 802049 786178 528380 813861 789075 678909 ] |
||||||||||||||||||||||||||||||
|
4.17 ms (2.39%) |
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 391926 397656 398354 400023 400689 428177 428305 432735 435386 437999 439475 441113 443170 445711 447789 454535 464705 464837 465172 465252 465923 466591 468348 468393 468438 469760 472324 473784 474737 477597 478073 489014 493610 494438 497507 498751 513219 513394 523541 528315 528380 528489 534432 541727 544976 545366 555170 561008 573270 577912 578298 580595 583597 588014 589472 590802 591259 595459 596738 603313 604338 604421 605437 618908 620259 623303 624484 624578 630289 648393 649516 652683 656498 659387 666374 678909 693897 706359 710418 710510 712553 712770 720099 720126 720174 720417 720664 723131 723153 724614 729090 729299 729962 732262 734324 750317 751424 751433 761189 763515 777003 782602 786178 788079 788852 788911 789075 790126 790542 791885 792171 796132 800896 802049 804309 813861 814457 817273 825876 826934 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hard amateur anal"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hard любительск анал"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hard любительск анал"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.87%) |
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.