Query Metrics
7
Database Queries
7
Different statements
175.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.17 ms (84.38%) |
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 388912 415954 420267 421520 429762 429898 430081 437686 443103 443636 447803 447851 448034 448878 448987 452535 456690 460412 464932 468433 470527 472784 474021 474688 475194 477073 477470 477553 477554 484571 484636 484818 485597 486706 488571 491508 491664 491776 492273 494171 494276 500971 506195 508156 509810 509879 510821 512447 512538 513710 513979 515329 516103 517847 518206 518558 519985 521738 522871 522976 523567 524417 524628 528791 529855 530024 530030 530053 530487 530637 530694 530703 530808 531174 532762 534027 537584 537595 541644 541721 542148 543848 545785 548552 550315 556774 558601 559886 560429 561136 561140 561142 561814 567347 575806 576079 576219 576371 576372 582972 583512 583670 583722 587879 590584 593863 605636 609958 610692 610786 628312 632383 640770 642723 644691 647952 650380 653889 782030 794944 ] |
||||||||||||||||||||||||||||||
|
18.07 ms (10.29%) |
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 523567 430081 509879 474688 437686 475194 593863 519985 610786 575806 491664 420267 576219 515329 477470 429898 528791 530053 468433 486706 492273 583670 605636 472784 429762 561142 448034 443103 477554 517847 530487 640770 447803 518206 448987 644691 464932 610692 447851 460412 556774 583722 388912 642723 794944 576371 561140 470527 456690 484571 509810 513979 484636 518558 561814 452535 415954 587879 576079 650380 537584 530030 531174 532762 647952 512538 448878 560429 506195 512447 522871 609958 545785 558601 541644 477553 474021 529855 521738 561136 508156 537595 576372 485597 530703 582972 530808 513710 524417 491776 534027 550315 488571 477073 421520 548552 632383 494171 516103 530694 500971 524628 530024 522976 541721 567347 542148 628312 510821 530637 484818 443636 543848 491508 559886 653889 494276 590584 782030 583512 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.57%) |
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 388912 415954 420267 421520 429762 429898 430081 437686 443103 443636 447803 447851 448034 448878 448987 452535 456690 460412 464932 468433 470527 472784 474021 474688 475194 477073 477470 477553 477554 484571 484636 484818 485597 486706 488571 491508 491664 491776 492273 494171 494276 500971 506195 508156 509810 509879 510821 512447 512538 513710 513979 515329 516103 517847 518206 518558 519985 521738 522871 522976 523567 524417 524628 528791 529855 530024 530030 530053 530487 530637 530694 530703 530808 531174 532762 534027 537584 537595 541644 541721 542148 543848 545785 548552 550315 556774 558601 559886 560429 561136 561140 561142 561814 567347 575806 576079 576219 576371 576372 582972 583512 583670 583722 587879 590584 593863 605636 609958 610692 610786 628312 632383 640770 642723 644691 647952 650380 653889 782030 794944 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bondage blowjob mmf"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм минет оральн секс мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бдсм минет оральн секс мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.84%) |
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.