Query Metrics
7
Database Queries
7
Different statements
172.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.61 ms (79.74%) |
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 6997 382242 382254 382959 383205 416931 424679 441110 441838 454113 456333 456818 460209 462381 463757 468827 474413 478151 479082 481920 490267 491463 495067 498730 499359 500375 505748 505888 507793 510172 511554 511916 512867 513265 514088 515391 521222 522343 523183 523189 530570 531114 531533 531884 532632 533183 533584 534221 536684 541206 543855 545480 554859 559569 563473 566777 568525 568561 579547 579614 585322 585476 593003 598859 599814 603269 621337 635050 640531 667772 714228 716736 720286 721454 729907 729917 731776 731802 735028 744904 745007 754462 755076 765376 765752 772694 773391 773877 781646 781663 781714 781731 781741 782148 782230 782252 785932 789407 790903 792584 799160 801214 804237 810045 815031 816371 817113 817284 817721 818812 819720 820229 820284 822045 824457 825015 825110 825762 826973 827327 ] |
||||||||||||||||||||||||||||||
|
24.64 ms (14.28%) |
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 790903 729907 755076 754462 773877 799160 801214 521222 441838 817284 815031 495067 510172 579547 481920 515391 536684 523189 531114 543855 640531 818812 820229 534221 721454 731776 782148 499359 781731 598859 579614 603269 505888 511554 512867 491463 6997 825015 532632 716736 720286 714228 804237 782230 810045 792584 463757 523183 462381 479082 498730 522343 454113 568525 635050 505748 513265 514088 541206 785932 824457 820284 817721 531884 554859 566777 667772 781714 789407 735028 819720 825110 826973 827327 817113 822045 474413 507793 533183 530570 585322 599814 729917 772694 731802 765376 773391 382254 563473 559569 511916 500375 533584 382959 621337 781741 383205 416931 490267 531533 781663 744904 745007 781646 782252 545480 441110 424679 816371 825762 456818 460209 478151 568561 593003 585476 765752 468827 456333 382242 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.51%) |
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 6997 382242 382254 382959 383205 416931 424679 441110 441838 454113 456333 456818 460209 462381 463757 468827 474413 478151 479082 481920 490267 491463 495067 498730 499359 500375 505748 505888 507793 510172 511554 511916 512867 513265 514088 515391 521222 522343 523183 523189 530570 531114 531533 531884 532632 533183 533584 534221 536684 541206 543855 545480 554859 559569 563473 566777 568525 568561 579547 579614 585322 585476 593003 598859 599814 603269 621337 635050 640531 667772 714228 716736 720286 721454 729907 729917 731776 731802 735028 744904 745007 754462 755076 765376 765752 772694 773391 773877 781646 781663 781714 781731 781741 782148 782230 782252 785932 789407 790903 792584 799160 801214 804237 810045 815031 816371 817113 817284 817721 818812 819720 820229 820284 822045 824457 825015 825110 825762 826973 827327 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bdsm bondage mature"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм бдсм mature"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бдсм бдсм mature"
]
|
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.