Query Metrics
7
Database Queries
7
Different statements
391.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.27 ms (52.64%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
157.16 ms (40.10%) |
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 467951 472483 472611 475328 481441 483559 484951 486171 493568 494437 494688 496616 499241 499860 499881 500240 501510 503444 506076 507041 509108 509610 510376 511616 512800 512937 514761 514995 515881 516637 516701 516730 517006 517481 517580 517634 517712 517717 518624 518919 518990 519850 520211 521084 521249 521470 522198 522933 523556 523563 525855 527223 527433 529275 529331 532516 533218 533634 534524 536408 536426 536455 536884 536887 538681 539489 539559 540227 540541 541321 542223 543552 544976 544977 545631 545926 549105 550685 551132 551779 555592 558903 559200 559996 561447 562957 563082 564390 564399 564517 564858 565887 568381 568427 568525 569149 570722 571086 571126 571144 571265 571441 572235 572707 574265 575665 576933 576944 577912 578207 578493 579471 579821 579856 581722 582404 582792 583710 584101 584879 ] |
||||||||||||||||||||||||||||||
|
19.18 ms (4.89%) |
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 536408 536884 503444 507041 509108 509610 514761 516637 517717 518990 519850 522198 522933 527433 533218 533634 536455 536887 494437 494688 496616 499241 499860 500240 501510 506076 510376 511616 512800 515881 516701 518919 520211 525855 529275 532516 534524 536426 538681 539489 539559 540227 540541 499881 512937 514995 516730 517006 517481 517580 517634 517712 518624 521084 521249 521470 523556 523563 527223 529331 467951 472483 472611 475328 481441 483559 484951 486171 493568 541321 544977 551779 558903 559200 561447 562957 564390 564399 564517 568427 570722 571265 575665 578493 579856 581722 584879 543552 544976 550685 559996 563082 568525 571126 576944 577912 578207 579821 582404 582792 583710 584101 542223 545631 545926 549105 551132 555592 564858 565887 568381 569149 571086 571144 571441 572235 572707 574265 576933 579471 ] |
||||||||||||||||||||||||||||||
|
3.48 ms (0.89%) |
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 467951 472483 472611 475328 481441 483559 484951 486171 493568 494437 494688 496616 499241 499860 499881 500240 501510 503444 506076 507041 509108 509610 510376 511616 512800 512937 514761 514995 515881 516637 516701 516730 517006 517481 517580 517634 517712 517717 518624 518919 518990 519850 520211 521084 521249 521470 522198 522933 523556 523563 525855 527223 527433 529275 529331 532516 533218 533634 534524 536408 536426 536455 536884 536887 538681 539489 539559 540227 540541 541321 542223 543552 544976 544977 545631 545926 549105 550685 551132 551779 555592 558903 559200 559996 561447 562957 563082 564390 564399 564517 564858 565887 568381 568427 568525 569149 570722 571086 571126 571144 571265 571441 572235 572707 574265 575665 576933 576944 577912 578207 578493 579471 579821 579856 581722 582404 582792 583710 584101 584879 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"большая смазка"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие смазк"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.