Query Metrics
8
Database Queries
8
Different statements
158.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.40 ms (79.63%) |
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 406075 408460 414357 414372 415963 423979 425353 427166 427981 429255 432843 441168 444391 447412 447615 447955 450579 452228 453324 456452 460879 462679 467508 473772 473781 474621 475056 481910 484372 489097 495937 496367 501598 505614 506529 507733 510553 511837 513061 515808 516682 518521 521306 521989 522434 523226 524281 528353 530582 539731 541804 542218 547620 548594 549860 550511 553108 554798 555291 560511 563446 565186 575713 580334 582631 583994 595891 597501 598067 598464 598510 598524 599404 599512 601314 601423 601906 601976 604289 607129 609292 611900 613263 617212 619965 620295 622778 634230 637243 649185 651938 652907 653267 654552 655087 655615 657438 663537 663930 669574 670239 686748 688390 688548 688664 ] |
||||||||||||||||||||||||||||||
|
18.78 ms (11.83%) |
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 425353 441168 415963 447955 475056 506529 523226 495937 510553 462679 669574 423979 408460 429255 501598 688548 598067 456452 522434 474621 513061 505614 450579 447615 473781 447412 452228 539731 670239 686748 432843 530582 598464 597501 550511 601423 414372 427166 515808 489097 414357 655087 598510 542218 688664 653267 460879 688390 453324 595891 548594 555291 507733 637243 609292 481910 583994 524281 655615 604289 547620 613263 467508 654552 620295 406075 663537 553108 473772 575713 601906 521989 582631 598524 599404 601976 580334 554798 663930 619965 444391 496367 516682 651938 518521 652907 511837 563446 427981 484372 528353 657438 601314 607129 634230 611900 549860 521306 599512 622778 541804 617212 565186 649185 560511 ] |
||||||||||||||||||||||||||||||
|
3.89 ms (2.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 406075 408460 414357 414372 415963 423979 425353 427166 427981 429255 432843 441168 444391 447412 447615 447955 450579 452228 453324 456452 460879 462679 467508 473772 473781 474621 475056 481910 484372 489097 495937 496367 501598 505614 506529 507733 510553 511837 513061 515808 516682 518521 521306 521989 522434 523226 524281 528353 530582 539731 541804 542218 547620 548594 549860 550511 553108 554798 555291 560511 563446 565186 575713 580334 582631 583994 595891 597501 598067 598464 598510 598524 599404 599512 601314 601423 601906 601976 604289 607129 609292 611900 613263 617212 619965 620295 622778 634230 637243 649185 651938 652907 653267 654552 655087 655615 657438 663537 663930 669574 670239 686748 688390 688548 688664 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк крича вперв"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl crying"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк крича вперв"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.15%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01–of&²r\x11³fÜe2ýF¿"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.03%) |
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.