Query Metrics
7
Database Queries
7
Different statements
212.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
183.13 ms (86.05%) |
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 391669 396879 399369 399662 405438 406324 407516 407648 407903 410980 419856 420549 421283 421873 421970 424232 424265 424274 425816 425962 430228 430732 430783 432821 433353 434097 435356 443397 443692 443707 443925 446864 447244 447897 450855 450881 451479 454222 454257 454555 456693 458724 463173 464018 464915 465331 465664 468355 469283 470613 472229 474421 475884 477104 478333 478806 479800 480415 482507 483362 487074 487153 487442 489443 491416 491566 492101 492332 492931 493108 493160 497517 500091 500339 501829 503577 504951 504970 506084 506225 506536 506580 508595 509378 512552 513153 513194 513981 514273 514631 515054 515372 516480 516485 516792 516829 517023 517100 519613 519726 519838 520402 521391 522128 523149 523777 524795 524875 524876 525233 525363 525802 526392 526521 526527 526528 528572 529209 535410 585137 ] |
||||||||||||||||||||||||||||||
|
19.38 ms (9.11%) |
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 421873 421970 424274 425816 430783 432821 435356 443397 447244 450855 451479 458724 463173 469283 474421 479800 391669 396879 399369 399662 405438 407516 407903 410980 419856 420549 424232 424265 425962 434097 443692 443707 443925 446864 454222 454257 454555 456693 465664 477104 480415 407648 421283 430228 430732 433353 447897 450881 464018 464915 465331 468355 470613 472229 475884 478333 478806 500091 508595 509378 513194 513981 516485 519726 523777 524876 526528 487074 487153 489443 491566 492101 493108 493160 500339 501829 506084 506225 514273 515054 516829 517023 519838 522128 523149 525802 526392 528572 483362 491416 492931 497517 506536 506580 512552 514631 516480 516792 520402 524795 524875 525363 526521 529209 487442 492332 503577 504951 504970 513153 515372 517100 519613 521391 525233 526527 535410 406324 585137 482507 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.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 391669 396879 399369 399662 405438 406324 407516 407648 407903 410980 419856 420549 421283 421873 421970 424232 424265 424274 425816 425962 430228 430732 430783 432821 433353 434097 435356 443397 443692 443707 443925 446864 447244 447897 450855 450881 451479 454222 454257 454555 456693 458724 463173 464018 464915 465331 465664 468355 469283 470613 472229 474421 475884 477104 478333 478806 479800 480415 482507 483362 487074 487153 487442 489443 491416 491566 492101 492332 492931 493108 493160 497517 500091 500339 501829 503577 504951 504970 506084 506225 506536 506580 508595 509378 512552 513153 513194 513981 514273 514631 515054 515372 516480 516485 516792 516829 517023 517100 519613 519726 519838 520402 521391 522128 523149 523777 524795 524875 524876 525233 525363 525802 526392 526521 526527 526528 528572 529209 535410 585137 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom bitch"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom женскийрод"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom женскийрод"
]
|
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.