Query Metrics
7
Database Queries
7
Different statements
176.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.32 ms (83.54%) |
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 6919 182526 383086 387251 390680 404342 413277 413971 415145 418013 419758 420352 423893 428570 434642 434822 435462 439151 439214 445103 445289 446300 447158 447315 452317 457140 457500 458868 460208 461456 464193 464306 467195 468039 469023 469566 470256 470968 474095 476137 476577 481584 485083 492170 496802 497030 501958 506038 508541 510588 514709 514828 515433 515523 515969 516025 518238 519530 519556 523868 525046 527975 530057 531180 531186 531223 531351 533697 536668 542524 543242 543871 545416 546837 550035 551275 558899 565265 567605 568301 569133 570411 571212 579629 583923 584001 586504 586889 587035 587292 597225 597227 597228 597232 602607 603773 604289 604513 615762 619439 624175 627805 632688 632979 634777 645004 645327 650764 676523 680149 680156 720836 722821 752588 760794 785412 786515 807927 811738 814908 ] |
||||||||||||||||||||||||||||||
|
18.71 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 415145 645004 458868 565265 518238 570411 515523 481584 543871 420352 460208 519530 514828 579629 182526 542524 597232 508541 445289 567605 6919 428570 383086 786515 785412 722821 468039 469023 586889 807927 514709 583923 531180 545416 645327 680156 506038 760794 571212 597225 597228 752588 404342 485083 390680 720836 476137 457140 519556 619439 496802 584001 615762 464193 814908 530057 680149 627805 811738 632688 413277 533697 446300 434822 523868 387251 469566 457500 676523 434642 439214 603773 650764 587292 445103 586504 476577 550035 525046 543242 435462 467195 536668 464306 515433 492170 531186 501958 604513 632979 624175 461456 531351 587035 602607 497030 546837 419758 516025 597227 568301 470256 439151 527975 634777 604289 452317 551275 569133 447158 474095 470968 447315 418013 515969 423893 558899 531223 510588 413971 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.45%) |
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 6919 182526 383086 387251 390680 404342 413277 413971 415145 418013 419758 420352 423893 428570 434642 434822 435462 439151 439214 445103 445289 446300 447158 447315 452317 457140 457500 458868 460208 461456 464193 464306 467195 468039 469023 469566 470256 470968 474095 476137 476577 481584 485083 492170 496802 497030 501958 506038 508541 510588 514709 514828 515433 515523 515969 516025 518238 519530 519556 523868 525046 527975 530057 531180 531186 531223 531351 533697 536668 542524 543242 543871 545416 546837 550035 551275 558899 565265 567605 568301 569133 570411 571212 579629 583923 584001 586504 586889 587035 587292 597225 597227 597228 597232 602607 603773 604289 604513 615762 619439 624175 627805 632688 632979 634777 645004 645327 650764 676523 680149 680156 720836 722821 752588 760794 785412 786515 807927 811738 814908 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal babe sex"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал babe секс"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал babe секс"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.99%) |
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.