Query Metrics
7
Database Queries
7
Different statements
181.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.92 ms (84.78%) |
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 391392 396120 401177 410227 416568 416580 416682 416688 416696 416708 416720 416752 430581 440016 440041 441074 446797 447151 447160 447198 448108 449104 450484 452889 454304 456222 456238 456239 460765 462384 465144 466474 466633 466636 467097 469221 470428 470479 483742 484809 486776 487428 488752 488820 490741 494999 497691 497696 497697 498297 498319 500338 502287 502796 505139 505382 505386 507376 510898 512931 515564 519697 522340 523357 524676 527920 530479 530659 531215 531347 532655 534372 536128 536783 537863 537864 540572 544843 545372 546211 548157 550816 567127 568264 573204 578484 583665 592259 597160 599833 599865 599880 599922 599927 605209 619286 619659 625780 628096 629963 630081 632571 632678 635975 636306 636958 639379 639745 639767 639796 641953 641996 648820 651674 656932 666892 669034 680816 695127 788193 ] |
||||||||||||||||||||||||||||||
|
17.30 ms (9.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 416682 470479 470428 498297 502287 497691 497697 466633 466636 548157 583665 680816 597160 416708 416568 465144 401177 456238 487428 488820 430581 619286 531215 632571 550816 568264 628096 507376 788193 666892 629963 456239 573204 450484 488752 540572 537863 632678 599833 599922 527920 536128 534372 537864 648820 544843 639796 410227 530479 505382 391392 416696 531347 500338 505386 578484 619659 448108 502796 536783 447160 460765 523357 656932 456222 441074 466474 512931 498319 416752 416688 416580 416720 462384 524676 505139 515564 546211 636958 639379 630081 467097 447198 452889 494999 483742 490741 651674 519697 532655 636306 669034 545372 599865 440041 530659 599880 599927 641953 635975 639745 639767 641996 440016 446797 454304 396120 522340 695127 510898 449104 469221 567127 592259 625780 605209 484809 447151 486776 497696 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.53%) |
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 391392 396120 401177 410227 416568 416580 416682 416688 416696 416708 416720 416752 430581 440016 440041 441074 446797 447151 447160 447198 448108 449104 450484 452889 454304 456222 456238 456239 460765 462384 465144 466474 466633 466636 467097 469221 470428 470479 483742 484809 486776 487428 488752 488820 490741 494999 497691 497696 497697 498297 498319 500338 502287 502796 505139 505382 505386 507376 510898 512931 515564 519697 522340 523357 524676 527920 530479 530659 531215 531347 532655 534372 536128 536783 537863 537864 540572 544843 545372 546211 548157 550816 567127 568264 573204 578484 583665 592259 597160 599833 599865 599880 599922 599927 605209 619286 619659 625780 628096 629963 630081 632571 632678 635975 636306 636958 639379 639745 639767 639796 641953 641996 648820 651674 656932 666892 669034 680816 695127 788193 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал фистинг"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал фистинг"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal and fisting"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.