Query Metrics
7
Database Queries
7
Different statements
359.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.08 ms (59.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"girlfriend русск"
]
|
||||||||||||||||||||||||||||||
|
122.52 ms (34.06%) |
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 422247 423815 424282 434953 436530 445756 448126 453598 455546 459571 461557 462040 462797 465154 465254 465934 469797 470112 479756 481646 481840 482494 483041 484120 484733 485520 488595 488916 490538 491557 492456 492841 493276 494400 495182 495442 496044 500204 505379 506379 506440 507466 507665 508288 509700 511233 511811 512165 513052 518348 521348 521543 521622 521951 523974 524536 525452 527705 544519 544893 546721 546972 548618 548621 550469 550509 551249 552359 553256 553258 554201 556714 558692 559007 563683 567315 567388 567409 569942 572671 574521 577728 587931 588277 590319 591393 591979 594023 601313 601507 604183 608234 610504 610833 613333 621807 623007 623355 624616 626067 628478 628480 635667 641506 647255 659464 667183 672283 677081 679198 690709 710614 712859 723629 737786 758388 776907 779247 783162 788342 ] |
||||||||||||||||||||||||||||||
|
16.31 ms (4.53%) |
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 424282 462040 461557 495442 506440 507466 485520 488595 488916 518348 572671 482494 511811 500204 552359 553258 567315 567388 567409 659464 610833 588277 590319 594023 601507 628478 587931 459571 469797 455546 462797 479756 434953 470112 481646 423815 445756 448126 422247 465154 465254 508288 511233 521951 484733 492456 492841 494400 495182 507665 513052 527705 484120 493276 496044 506379 509700 521622 524536 483041 490538 491557 505379 512165 521348 521543 436530 465934 453598 525452 523974 723629 481840 546721 548618 558692 559007 544519 546972 550509 553256 554201 556714 563683 569942 544893 550469 551249 574521 667183 672283 677081 647255 679198 690709 710614 712859 548621 577728 591979 621807 601313 604183 626067 641506 610504 623007 624616 628480 591393 608234 613333 623355 635667 776907 788342 779247 783162 737786 758388 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (0.78%) |
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 422247 423815 424282 434953 436530 445756 448126 453598 455546 459571 461557 462040 462797 465154 465254 465934 469797 470112 479756 481646 481840 482494 483041 484120 484733 485520 488595 488916 490538 491557 492456 492841 493276 494400 495182 495442 496044 500204 505379 506379 506440 507466 507665 508288 509700 511233 511811 512165 513052 518348 521348 521543 521622 521951 523974 524536 525452 527705 544519 544893 546721 546972 548618 548621 550469 550509 551249 552359 553256 553258 554201 556714 558692 559007 563683 567315 567388 567409 569942 572671 574521 577728 587931 588277 590319 591393 591979 594023 601313 601507 604183 608234 610504 610833 613333 621807 623007 623355 624616 626067 628478 628480 635667 641506 647255 659464 667183 672283 677081 679198 690709 710614 712859 723629 737786 758388 776907 779247 783162 788342 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girlfriend russian"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"girlfriend русск"
]
|
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.