Query Metrics
7
Database Queries
7
Different statements
144.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.53 ms (82.97%) |
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 20907 153364 165570 166675 265847 327421 382176 383153 383560 383744 386371 387374 392696 396337 396928 398609 400732 401122 401507 401513 404841 407566 408539 409949 410724 411009 411196 412474 413712 413745 417658 418428 419143 419165 420230 420252 422589 428728 429025 429949 444117 447928 456639 456886 457259 457267 460474 462288 463752 469803 475804 478425 491448 491453 500712 512224 513193 514341 522190 524387 534922 538674 542219 550644 550752 551941 551995 552053 552638 552896 554071 554298 556366 558367 558421 559866 559902 559905 564798 565471 565473 568869 578420 578685 580100 580269 583633 584794 585781 590944 595792 596422 601317 606699 613163 614731 619432 619455 623601 623610 641452 643379 644363 653240 654369 690866 717921 727903 730894 735602 740928 742480 743426 743436 753216 754812 785021 791307 793630 812879 ] |
||||||||||||||||||||||||||||||
|
15.05 ms (10.45%) |
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 410724 551941 559905 550752 551995 554298 578685 584794 595792 513193 407566 512224 558367 392696 382176 396337 400732 401122 422589 411196 522190 514341 500712 558421 542219 559902 717921 552638 580100 585781 596422 614731 606699 619432 641452 785021 740928 754812 793630 730894 735602 743436 742480 727903 623601 644363 812879 417658 420230 383153 265847 404841 491448 791307 753216 401507 387374 383744 428728 429025 420252 457259 463752 534922 578420 654369 565473 590944 409949 554071 411009 327421 408539 413712 456886 457267 478425 524387 552053 559866 619455 623610 419165 412474 475804 386371 153364 166675 20907 419143 413745 418428 429949 447928 469803 460474 538674 491453 550644 552896 556366 580269 690866 653240 643379 613163 456639 398609 401513 462288 583633 165570 564798 568869 743426 565471 601317 383560 396928 444117 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (2.16%) |
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 20907 153364 165570 166675 265847 327421 382176 383153 383560 383744 386371 387374 392696 396337 396928 398609 400732 401122 401507 401513 404841 407566 408539 409949 410724 411009 411196 412474 413712 413745 417658 418428 419143 419165 420230 420252 422589 428728 429025 429949 444117 447928 456639 456886 457259 457267 460474 462288 463752 469803 475804 478425 491448 491453 500712 512224 513193 514341 522190 524387 534922 538674 542219 550644 550752 551941 551995 552053 552638 552896 554071 554298 556366 558367 558421 559866 559902 559905 564798 565471 565473 568869 578420 578685 580100 580269 583633 584794 585781 590944 595792 596422 601317 606699 613163 614731 619432 619455 623601 623610 641452 643379 644363 653240 654369 690866 717921 727903 730894 735602 740928 742480 743426 743436 753216 754812 785021 791307 793630 812879 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vagina asian"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вагин азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.98%) |
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.