Query Metrics
7
Database Queries
7
Different statements
180.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.34 ms (84.19%) |
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 95991 399568 402887 415814 420606 420652 424105 425144 425149 426868 428963 433282 436049 436418 437161 438366 439020 440649 441940 445274 445384 446449 446604 447551 448148 452181 455131 456646 457340 458286 458869 459732 460059 460548 462274 462295 462523 463672 464781 466752 467828 473308 473523 473642 473645 473903 474107 477147 477176 478693 479273 480975 483232 483238 485588 485663 487380 487698 490715 491549 492456 492498 493276 494350 495182 495327 495965 501303 501340 501747 503682 504069 504834 505863 508175 508755 510071 510665 510721 511122 513344 513420 514788 516157 516538 516914 517178 517940 518309 518335 518899 519803 521629 521933 521951 522267 524436 524507 524577 525759 527713 528106 529511 552622 553258 559780 560794 562607 562803 563744 567315 568845 575555 584424 597190 632851 754078 771591 773241 ] |
||||||||||||||||||||||||||||||
|
19.34 ms (10.69%) |
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 492498 494350 504069 510071 516538 524507 754078 426868 517940 473523 773241 518309 462295 458286 575555 562607 568845 584424 559780 425144 438366 459732 463672 474107 428963 441940 433282 473903 424105 437161 448148 456646 447551 467828 504834 512847 521951 483232 490715 492456 495182 503682 510721 513344 513420 522267 525759 529511 493276 501303 510665 518335 521933 485663 495965 501747 516157 516914 524436 528106 464781 420652 95991 478693 439020 462523 560794 563744 567315 436049 473642 446604 477176 445384 462274 420606 452181 457340 458869 415814 425149 446449 479273 521629 508755 483238 487380 485588 487698 505863 519803 527713 440649 445274 514788 495327 632851 399568 552622 473308 480975 460059 524577 491549 562803 771591 436418 473645 455131 477147 501340 518899 508175 511122 597190 553258 402887 460548 466752 517178 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.32%) |
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 95991 399568 402887 415814 420606 420652 424105 425144 425149 426868 428963 433282 436049 436418 437161 438366 439020 440649 441940 445274 445384 446449 446604 447551 448148 452181 455131 456646 457340 458286 458869 459732 460059 460548 462274 462295 462523 463672 464781 466752 467828 473308 473523 473642 473645 473903 474107 477147 477176 478693 479273 480975 483232 483238 485588 485663 487380 487698 490715 491549 492456 492498 493276 494350 495182 495327 495965 501303 501340 501747 503682 504069 504834 505863 508175 508755 510071 510665 510721 511122 513344 513420 514788 516157 516538 516914 517178 517940 518309 518335 518899 519803 521629 521933 521951 522267 524436 524507 524577 525759 527713 528106 529511 552622 553258 559780 560794 562607 562803 563744 567315 568845 575555 584424 597190 632851 754078 771591 773241 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian girls"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск девушк"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.80%) |
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.