Query Metrics
7
Database Queries
7
Different statements
350.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.59 ms (59.79%) |
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 382585 393845 399306 422335 426200 428302 429060 431161 446335 447528 450251 455937 458722 459228 466237 470337 478483 492565 492613 497420 497453 509588 524002 526734 530319 531780 532625 548607 552098 552187 552224 557685 559179 561701 561716 563834 564427 565024 565952 567738 569097 570408 570593 570613 571582 573414 573568 573792 573895 573901 574897 575071 575075 575344 575452 576326 576836 578366 578391 579735 580688 580704 587930 595424 597490 597547 597808 597951 597962 598021 598662 600330 604140 604145 604553 606979 609645 615713 619427 623004 623175 623204 624296 628388 631196 647043 648246 651875 652949 655346 655633 658616 661283 677338 679383 681343 698045 712803 713550 716559 717719 717986 719640 720394 720822 721736 724724 730302 734432 736101 742124 742937 744097 748192 753155 754197 766871 811832 816503 818682 ] |
||||||||||||||||||||||||||||||
|
120.10 ms (34.26%) |
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 382585 393845 399306 422335 426200 428302 429060 431161 446335 447528 450251 455937 458722 459228 466237 470337 478483 492565 492613 497420 497453 509588 524002 526734 530319 531780 532625 548607 552098 552187 552224 557685 559179 561701 561716 563834 564427 565024 565952 567738 569097 570408 570593 570613 571582 573414 573568 573792 573895 573901 574897 575071 575075 575344 575452 576326 576836 578366 578391 579735 580688 580704 587930 595424 597490 597547 597808 597951 597962 598021 598662 600330 604140 604145 604553 606979 609645 615713 619427 623004 623175 623204 624296 628388 631196 647043 648246 651875 652949 655346 655633 658616 661283 677338 679383 681343 698045 712803 713550 716559 717719 717986 719640 720394 720822 721736 724724 730302 734432 736101 742124 742937 744097 748192 753155 754197 766871 811832 816503 818682 ] |
||||||||||||||||||||||||||||||
|
13.77 ms (3.93%) |
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 753155 609645 719640 458722 492613 450251 497420 531780 509588 720394 597951 459228 393845 466237 470337 428302 447528 526734 524002 492565 655633 565952 623204 619427 734432 818682 530319 648246 713550 606979 742124 742937 754197 422335 816503 446335 497453 548607 557685 571582 575071 580688 570408 552224 561716 573568 575452 576326 580704 712803 717986 573414 578366 598021 736101 604553 598662 766871 399306 431161 478483 647043 744097 748192 426200 552098 565024 561701 677338 661283 679383 587930 597808 597962 597547 382585 574897 569097 600330 628388 578391 570593 564427 573901 570613 623175 698045 532625 730302 455937 579735 597490 631196 429060 573792 575344 552187 559179 563834 567738 576836 651875 652949 658616 720822 721736 716559 655346 681343 717719 573895 575075 623004 595424 624296 604145 615713 604140 811832 724724 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen small dick"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen маленькая член"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen маленькая член"
]
|
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.