Query Metrics
7
Database Queries
7
Different statements
199.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.52 ms (86.07%) |
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 203528 340635 382207 383389 385688 387287 387720 389182 389771 392423 395489 396606 401053 401262 404415 413078 414342 415737 416000 419342 420140 424614 426283 429608 429890 430088 434716 441040 442997 445623 445880 446095 446533 449679 449930 453408 454793 456219 457480 465468 468575 468823 468946 469584 472429 473366 473368 478437 482805 482961 485719 493262 496086 497691 498697 500915 500923 502212 504154 513188 514229 514886 516568 526504 527508 528104 531657 531804 531907 534567 545328 551987 553808 555258 577038 592369 592681 597160 610573 612291 613777 641997 651635 664531 666072 671839 678099 682478 686549 694178 700975 707432 713188 715362 716973 720438 720678 724470 742474 748549 752667 765668 790918 791550 794752 795879 796717 796936 801610 807590 809228 810016 811994 815559 816547 818387 818460 819565 820119 821409 ] |
||||||||||||||||||||||||||||||
|
17.06 ms (8.56%) |
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 514229 534567 551987 713188 666072 686549 610573 612291 790918 796717 742474 715362 796936 795879 416000 496086 426283 453408 414342 429608 678099 801610 442997 429890 504154 664531 716973 671839 794752 810016 720678 389182 820119 385688 383389 203528 392423 395489 382207 389771 387287 387720 396606 401053 401262 404415 424614 434716 419342 441040 413078 420140 415737 430088 818460 818387 819565 821409 815559 816547 482805 449679 445623 445880 446533 456219 468823 468946 469584 472429 473366 478437 482961 446095 449930 454793 457480 493262 500923 516568 526504 527508 528104 531907 497691 500915 502212 513188 514886 531657 498697 531804 465468 468575 473368 485719 553808 577038 545328 694178 700975 682478 651635 720438 555258 597160 592369 592681 613777 641997 811994 791550 807590 724470 752667 748549 765668 707432 809228 340635 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.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 203528 340635 382207 383389 385688 387287 387720 389182 389771 392423 395489 396606 401053 401262 404415 413078 414342 415737 416000 419342 420140 424614 426283 429608 429890 430088 434716 441040 442997 445623 445880 446095 446533 449679 449930 453408 454793 456219 457480 465468 468575 468823 468946 469584 472429 473366 473368 478437 482805 482961 485719 493262 496086 497691 498697 500915 500923 502212 504154 513188 514229 514886 516568 526504 527508 528104 531657 531804 531907 534567 545328 551987 553808 555258 577038 592369 592681 597160 610573 612291 613777 641997 651635 664531 666072 671839 678099 682478 686549 694178 700975 707432 713188 715362 716973 720438 720678 724470 742474 748549 752667 765668 790918 791550 794752 795879 796717 796936 801610 807590 809228 810016 811994 815559 816547 818387 818460 819565 820119 821409 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор волосатая"
]
|
||||||||||||||||||||||||||||||
|
2.22 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"extreme hairy"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.84%) |
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.