Query Metrics
7
Database Queries
7
Different statements
203.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.14 ms (84.59%) |
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 402731 407637 411430 415777 421776 422356 427592 429526 434772 436588 437257 438878 439358 439642 441763 442989 444608 446060 446237 448096 451490 451545 452334 452551 453781 454035 456382 456438 457189 457389 457392 458219 460560 461342 461800 461822 462900 464116 464970 466147 467738 467834 469704 470103 471939 473793 475205 476454 476998 478474 478711 479189 479583 479889 481043 485008 487393 488059 488331 489425 489621 492496 492648 494277 495049 495057 495474 495940 496181 496959 497700 498512 499120 499943 500356 500964 505479 505870 509091 511046 513563 513950 515851 516072 516893 520048 520136 521346 522515 524156 525284 525454 525833 526463 526992 528063 542755 542787 542918 544062 546879 552571 564991 586330 601204 605833 618389 634891 642444 643928 648262 653972 666470 678644 691138 696920 699583 748046 772753 788519 ] |
||||||||||||||||||||||||||||||
|
19.56 ms (9.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 473793 442989 522515 485008 520136 429526 422356 436588 438878 452334 470103 544062 648262 691138 546879 586330 605833 634891 618389 452551 454035 456382 467834 446060 451490 411430 437257 466147 499943 488331 489425 495474 505479 515851 516072 444608 421776 448096 462900 471939 457392 460560 479189 494277 495049 500356 500964 505870 511046 464116 476998 478474 479889 542755 542918 552571 542787 666470 678644 699583 564991 601204 748046 772753 643928 696920 788519 441763 446237 481043 402731 451545 461800 475205 478711 479583 467738 476454 434772 439642 456438 461342 439358 458219 513563 526992 488059 489621 496959 499120 513950 521346 525284 495940 497700 498512 509091 524156 525833 526463 487393 492496 492648 496181 516893 520048 525454 495057 464970 528063 653972 642444 453781 461822 427592 407637 415777 457189 457389 469704 ] |
||||||||||||||||||||||||||||||
|
3.55 ms (1.74%) |
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 402731 407637 411430 415777 421776 422356 427592 429526 434772 436588 437257 438878 439358 439642 441763 442989 444608 446060 446237 448096 451490 451545 452334 452551 453781 454035 456382 456438 457189 457389 457392 458219 460560 461342 461800 461822 462900 464116 464970 466147 467738 467834 469704 470103 471939 473793 475205 476454 476998 478474 478711 479189 479583 479889 481043 485008 487393 488059 488331 489425 489621 492496 492648 494277 495049 495057 495474 495940 496181 496959 497700 498512 499120 499943 500356 500964 505479 505870 509091 511046 513563 513950 515851 516072 516893 520048 520136 521346 522515 524156 525284 525454 525833 526463 526992 528063 542755 542787 542918 544062 546879 552571 564991 586330 601204 605833 618389 634891 642444 643928 648262 653972 666470 678644 691138 696920 699583 748046 772753 788519 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big neighbor"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие neighbor"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие neighbor"
]
|
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.