Query Metrics
7
Database Queries
7
Different statements
207.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.02 ms (86.24%) |
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 145706 315244 340635 382207 382813 383869 384271 385690 391371 397973 398112 401978 409016 411009 414595 416000 419292 419619 420299 421257 426283 426301 429860 429886 432884 434349 440641 441040 445950 448795 452363 454793 465125 477500 483522 483745 485661 494293 495737 496842 496999 499919 499927 507243 525839 527503 527536 529617 530428 531347 539639 540032 544912 553769 567508 569315 574377 574391 577038 590370 590730 594143 594491 595538 595591 595975 598692 600144 606254 609887 620957 622658 630254 637347 649372 653388 661424 666160 668305 671094 672754 691558 692722 709128 710280 710878 717660 722681 723877 725153 728635 729069 730309 735931 738468 738469 745874 749493 749588 751706 752755 761430 787238 788529 790711 795816 798759 800657 803510 807827 808125 812467 812540 816102 821359 821964 822969 824351 824531 824630 ] |
||||||||||||||||||||||||||||||
|
16.20 ms (7.80%) |
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 728635 383869 434349 507243 429860 429886 448795 483522 630254 530428 609887 752755 590730 496842 499927 672754 384271 790711 787238 808125 738469 803510 540032 661424 594491 709128 397973 539639 145706 821964 527536 567508 653388 595975 735931 717660 483745 401978 432884 606254 391371 419292 440641 411009 398112 577038 824351 816102 668305 590370 382813 385690 499919 666160 409016 527503 315244 426301 710280 710878 691558 730309 821359 822969 477500 494293 553769 692722 544912 595591 595538 637347 800657 723877 788529 795816 812467 452363 824531 414595 485661 529617 574377 574391 594143 600144 745874 465125 496999 569315 725153 598692 420299 382207 441040 454793 340635 445950 416000 426283 749588 531347 495737 419619 421257 525839 649372 620957 798759 751706 761430 738468 671094 722681 812540 729069 749493 622658 807827 824630 ] |
||||||||||||||||||||||||||||||
|
4.65 ms (2.24%) |
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 145706 315244 340635 382207 382813 383869 384271 385690 391371 397973 398112 401978 409016 411009 414595 416000 419292 419619 420299 421257 426283 426301 429860 429886 432884 434349 440641 441040 445950 448795 452363 454793 465125 477500 483522 483745 485661 494293 495737 496842 496999 499919 499927 507243 525839 527503 527536 529617 530428 531347 539639 540032 544912 553769 567508 569315 574377 574391 577038 590370 590730 594143 594491 595538 595591 595975 598692 600144 606254 609887 620957 622658 630254 637347 649372 653388 661424 666160 668305 671094 672754 691558 692722 709128 710280 710878 717660 722681 723877 725153 728635 729069 730309 735931 738468 738469 745874 749493 749588 751706 752755 761430 787238 788529 790711 795816 798759 800657 803510 807827 808125 812467 812540 816102 821359 821964 822969 824351 824531 824630 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo hairy"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.67 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.