Query Metrics
7
Database Queries
7
Different statements
164.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.48 ms (85.18%) |
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 21576 371547 392393 400535 402434 404339 408470 408770 410953 413258 413294 416441 418699 424952 425026 425757 426100 427869 429169 429349 429947 433553 436001 437676 440617 445577 452621 454155 454660 456524 457030 460080 460661 461531 461582 467384 469898 470048 470341 470380 470530 474615 475608 476681 478554 480135 482258 483026 483259 483430 483721 484058 484350 484754 485298 487086 489308 489584 491514 491739 492158 493115 494359 494397 494499 495550 495582 497262 498603 498922 500698 502047 502321 502720 502772 503892 504743 505186 505324 505494 506217 507983 508120 509761 509765 511060 512234 512259 513788 515586 518942 518951 519021 519281 520417 520706 521308 521363 521368 521825 521934 522412 522820 524701 525144 525216 527578 528275 529359 533351 558268 562243 577314 599962 652921 653458 656087 689167 701452 826050 ] |
||||||||||||||||||||||||||||||
|
14.64 ms (8.88%) |
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 467384 470341 474615 476681 480135 21576 371547 392393 402434 404339 408770 410953 413258 413294 416441 418699 426100 427869 429169 429349 429947 433553 437676 440617 445577 452621 454155 454660 457030 460661 461582 469898 470048 470380 478554 482258 408470 424952 425026 425757 436001 456524 460080 461531 470530 475608 502047 502321 502772 507983 518951 521825 522820 527578 484350 487086 489308 492158 494359 494397 494499 495550 498922 502720 505186 505324 505494 508120 509765 512259 513788 520706 522412 528275 483026 483259 489584 498603 503892 504743 506217 512234 519021 519281 521368 521934 525144 525216 529359 483430 483721 484058 484754 485298 491514 491739 493115 495582 497262 500698 509761 511060 515586 518942 520417 521308 521363 524701 533351 562243 652921 653458 599962 400535 826050 577314 558268 656087 689167 701452 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.57%) |
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 21576 371547 392393 400535 402434 404339 408470 408770 410953 413258 413294 416441 418699 424952 425026 425757 426100 427869 429169 429349 429947 433553 436001 437676 440617 445577 452621 454155 454660 456524 457030 460080 460661 461531 461582 467384 469898 470048 470341 470380 470530 474615 475608 476681 478554 480135 482258 483026 483259 483430 483721 484058 484350 484754 485298 487086 489308 489584 491514 491739 492158 493115 494359 494397 494499 495550 495582 497262 498603 498922 500698 502047 502321 502720 502772 503892 504743 505186 505324 505494 506217 507983 508120 509761 509765 511060 512234 512259 513788 515586 518942 518951 519021 519281 520417 520706 521308 521363 521368 521825 521934 522412 522820 524701 525144 525216 527578 528275 529359 533351 558268 562243 577314 599962 652921 653458 656087 689167 701452 826050 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"красавицу"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.