Query Metrics
7
Database Queries
7
Different statements
162.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.86 ms (83.37%) |
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 391147 411884 417473 420351 420648 421865 421879 422145 422154 422169 422189 422190 422203 423571 423923 424305 426765 426865 426988 426993 428778 433291 439666 448195 449723 454439 454812 456603 457428 469347 471923 475258 475266 483628 484283 488549 493155 496636 497311 502487 508195 509642 510222 510272 512613 513182 513471 513738 515018 515433 515974 517325 519962 520015 521091 521166 522186 522759 522968 523351 523841 524142 525265 526951 527908 527982 528087 528343 530863 532865 549027 549103 550841 555233 556806 562964 569003 569128 569829 572825 575890 580750 580808 582797 586009 586014 589573 590691 590867 591082 598190 600302 602563 623702 623978 629918 636371 652316 654688 707844 749926 750723 751572 763741 765313 765752 775809 782516 784481 787121 788184 800285 811220 812833 812836 812934 813084 820995 821568 822783 ] |
||||||||||||||||||||||||||||||
|
17.29 ms (10.61%) |
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 471923 508195 522186 475258 550841 527908 590867 513182 586014 590691 812833 812934 813084 525265 523351 569003 549027 572825 589573 623702 586009 475266 422169 422190 509642 484283 521166 523841 528343 765313 423571 820995 449723 530863 654688 636371 600302 788184 787121 811220 784481 751572 765752 488549 555233 556806 562964 580750 433291 454812 422145 439666 421865 426865 428778 456603 512613 527982 391147 526951 575890 775809 426988 497311 591082 424305 515018 580808 549103 598190 782516 629918 426765 426993 423923 510272 513471 517325 411884 821568 822783 515974 421879 422154 422203 448195 502487 522759 623978 602563 812836 750723 532865 510222 522968 528087 569128 582797 652316 763741 749926 800285 417473 493155 496636 520015 521091 519962 569829 457428 420648 422189 454439 469347 420351 515433 483628 513738 524142 707844 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (2.02%) |
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 391147 411884 417473 420351 420648 421865 421879 422145 422154 422169 422189 422190 422203 423571 423923 424305 426765 426865 426988 426993 428778 433291 439666 448195 449723 454439 454812 456603 457428 469347 471923 475258 475266 483628 484283 488549 493155 496636 497311 502487 508195 509642 510222 510272 512613 513182 513471 513738 515018 515433 515974 517325 519962 520015 521091 521166 522186 522759 522968 523351 523841 524142 525265 526951 527908 527982 528087 528343 530863 532865 549027 549103 550841 555233 556806 562964 569003 569128 569829 572825 575890 580750 580808 582797 586009 586014 589573 590691 590867 591082 598190 600302 602563 623702 623978 629918 636371 652316 654688 707844 749926 750723 751572 763741 765313 765752 775809 782516 784481 787121 788184 800285 811220 812833 812836 812934 813084 820995 821568 822783 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov anal mom"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов анал mom"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов анал mom"
]
|
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.