Query Metrics
7
Database Queries
7
Different statements
379.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.04 ms (55.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
141.69 ms (37.29%) |
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 388325 388847 409506 414445 421571 422074 424449 424492 428250 436393 439518 439714 440991 441110 445397 446794 447086 448374 448800 451258 454658 464345 464348 467888 468011 468462 470774 471934 474776 474895 475927 477069 477073 478832 486685 489973 491463 491784 494231 494233 495064 495737 496220 496353 496772 497005 498626 499084 500907 504668 504970 510024 511259 512459 513261 515511 515969 517418 518130 520778 522187 523019 525418 526047 527882 530713 531133 531212 531231 533727 533932 534019 535023 535025 535546 536335 536801 537912 538608 541822 541872 542397 543552 543840 543854 543867 546838 555114 558819 565160 565484 565630 571671 580259 587951 590149 596082 597216 598859 600252 600274 600312 600356 601578 603269 619469 624229 629886 632008 638137 648219 717859 720308 738674 739860 811993 814625 817023 817156 818160 ] |
||||||||||||||||||||||||||||||
|
20.56 ms (5.41%) |
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 817156 448374 638137 738674 598859 525418 477073 587951 424449 445397 531231 536335 555114 565630 447086 422074 474776 497005 511259 515511 496772 504668 512459 533932 536801 537912 546838 543552 571671 629886 468462 504970 814625 817023 527882 565484 542397 717859 600274 600356 632008 619469 739860 720308 421571 543840 603269 590149 491463 535023 494233 498626 543854 478832 439714 535025 495064 409506 467888 515969 531212 499084 439518 526047 428250 471934 474895 448800 535546 495737 510024 558819 624229 811993 446794 424492 600312 440991 491784 441110 414445 468011 496220 496353 464345 580259 436393 520778 533727 523019 522187 600252 601578 597216 486685 470774 494231 454658 541822 541872 596082 475927 388325 451258 464348 534019 500907 513261 518130 538608 565160 648219 517418 388847 818160 477069 489973 530713 531133 543867 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (0.67%) |
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 388325 388847 409506 414445 421571 422074 424449 424492 428250 436393 439518 439714 440991 441110 445397 446794 447086 448374 448800 451258 454658 464345 464348 467888 468011 468462 470774 471934 474776 474895 475927 477069 477073 478832 486685 489973 491463 491784 494231 494233 495064 495737 496220 496353 496772 497005 498626 499084 500907 504668 504970 510024 511259 512459 513261 515511 515969 517418 518130 520778 522187 523019 525418 526047 527882 530713 531133 531212 531231 533727 533932 534019 535023 535025 535546 536335 536801 537912 538608 541822 541872 542397 543552 543840 543854 543867 546838 555114 558819 565160 565484 565630 571671 580259 587951 590149 596082 597216 598859 600252 600274 600312 600356 601578 603269 619469 624229 629886 632008 638137 648219 717859 720308 738674 739860 811993 814625 817023 817156 818160 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал доминирован"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal slave"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал доминирован"
]
|
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.