Query Metrics
7
Database Queries
7
Different statements
157.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.40 ms (80.75%) |
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 146800 159291 393326 396519 401177 401178 405020 414064 416568 416580 416678 416688 416692 416701 416708 416720 428229 441074 441149 443198 447160 447198 449104 450572 450697 452885 452889 456222 456238 457483 457512 460765 461704 462384 465144 466474 466633 466636 467097 468684 469221 470428 473413 477149 479542 483742 487418 487428 488820 490741 493691 494999 497691 497697 498297 498319 502287 505139 512931 515564 523357 524676 525700 530026 531255 533519 534149 534229 545305 546211 548157 567127 576444 583665 592259 597160 609639 609804 625780 630081 632283 633731 636958 639379 639762 639787 639809 641562 641569 647905 647914 647993 656932 662159 663317 666528 666535 666550 666850 666875 666878 666902 674968 675375 680816 713113 717553 720756 729698 735152 737605 740269 751428 752592 761430 775883 780650 792706 816094 822975 ] |
||||||||||||||||||||||||||||||
|
19.20 ms (12.17%) |
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 457483 470428 498297 502287 497691 497697 466633 466636 548157 583665 680816 675375 597160 416708 416568 465144 477149 401177 456238 450697 487428 488820 159291 666850 531255 647993 632283 447160 460765 523357 487418 656932 609639 639787 456222 461704 441074 466474 512931 525700 498319 735152 146800 737605 822975 729698 530026 674968 534149 393326 662159 713113 663317 609804 641569 641562 775883 740269 534229 545305 666535 666875 666528 666878 647905 666902 533519 666550 647914 639762 396519 792706 449104 469221 567127 592259 625780 416692 441149 443198 816094 493691 576444 633731 780650 751428 416701 452885 405020 450572 473413 639809 401178 416688 414064 416580 416678 416720 462384 524676 505139 515564 546211 636958 639379 630081 467097 457512 447198 468684 452889 479542 428229 494999 483742 490741 717553 720756 761430 752592 ] |
||||||||||||||||||||||||||||||
|
3.65 ms (2.31%) |
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 146800 159291 393326 396519 401177 401178 405020 414064 416568 416580 416678 416688 416692 416701 416708 416720 428229 441074 441149 443198 447160 447198 449104 450572 450697 452885 452889 456222 456238 457483 457512 460765 461704 462384 465144 466474 466633 466636 467097 468684 469221 470428 473413 477149 479542 483742 487418 487428 488820 490741 493691 494999 497691 497697 498297 498319 502287 505139 512931 515564 523357 524676 525700 530026 531255 533519 534149 534229 545305 546211 548157 567127 576444 583665 592259 597160 609639 609804 625780 630081 632283 633731 636958 639379 639762 639787 639809 641562 641569 647905 647914 647993 656932 662159 663317 666528 666535 666550 666850 666875 666878 666902 674968 675375 680816 713113 717553 720756 729698 735152 737605 740269 751428 752592 761430 775883 780650 792706 816094 822975 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens anal fisting"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens анал фистинг"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens анал фистинг"
]
|
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.