Query Metrics
7
Database Queries
7
Different statements
206.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
180.69 ms (87.55%) |
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 383238 384339 397869 401546 417580 417682 418817 425529 429020 430267 430347 436047 438052 441049 453204 455460 455608 457074 457946 458124 460384 464971 466700 471121 475404 476646 479936 483523 484241 486783 487008 489451 494495 495204 502018 502447 504781 506683 511455 512143 514277 515259 521556 529154 537048 549654 550021 555111 560908 561919 569779 579519 584418 595016 596799 598943 600362 602320 609696 617115 678724 682611 684681 697111 701465 702864 713143 716695 723859 731174 731762 731785 734412 734826 737055 738532 739133 739149 739176 741764 745943 747302 752251 752474 752496 752667 755502 758806 760367 764556 765379 774855 777756 777942 780334 781310 781859 782987 783210 785986 787075 796792 798706 800549 800676 803147 803778 808324 808524 809076 809132 810762 810797 811446 814035 814039 816728 816756 826142 826613 ] |
||||||||||||||||||||||||||||||
|
14.38 ms (6.97%) |
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 738532 752667 483523 816728 609696 678724 502447 826613 739176 796792 441049 455608 561919 397869 826142 495204 537048 781310 598943 803147 383238 511455 529154 436047 506683 555111 809076 458124 455460 418817 484241 780334 800549 584418 512143 701465 602320 809132 723859 808324 739149 486783 521556 475404 384339 549654 401546 595016 430347 489451 457074 460384 417580 425529 515259 814039 697111 752474 783210 734412 734826 760367 747302 579519 476646 569779 781859 765379 464971 479936 716695 798706 764556 782987 430267 816756 702864 800676 808524 810797 811446 745943 713143 487008 600362 810762 755502 739133 752251 758806 731174 737055 502018 429020 471121 514277 494495 550021 560908 453204 596799 787075 741764 438052 417682 814035 682611 774855 777756 777942 803778 752496 731762 785986 504781 617115 457946 466700 684681 731785 ] |
||||||||||||||||||||||||||||||
|
3.66 ms (1.77%) |
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 383238 384339 397869 401546 417580 417682 418817 425529 429020 430267 430347 436047 438052 441049 453204 455460 455608 457074 457946 458124 460384 464971 466700 471121 475404 476646 479936 483523 484241 486783 487008 489451 494495 495204 502018 502447 504781 506683 511455 512143 514277 515259 521556 529154 537048 549654 550021 555111 560908 561919 569779 579519 584418 595016 596799 598943 600362 602320 609696 617115 678724 682611 684681 697111 701465 702864 713143 716695 723859 731174 731762 731785 734412 734826 737055 738532 739133 739149 739176 741764 745943 747302 752251 752474 752496 752667 755502 758806 760367 764556 765379 774855 777756 777942 780334 781310 781859 782987 783210 785986 787075 796792 798706 800549 800676 803147 803778 808324 808524 809076 809132 810762 810797 811446 814035 814039 816728 816756 826142 826613 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo hot girl"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд hot девушк"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд hot девушк"
]
|
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.