Query Metrics
7
Database Queries
7
Different statements
199.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.00 ms (87.19%) |
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 16679 21500 73421 96955 108054 146341 207970 339474 339770 382078 386057 388542 389176 397980 405716 410180 410954 413417 414055 416297 417849 418547 418729 418840 418861 418866 418895 420126 423563 423658 424535 425440 425545 426809 428335 430309 431421 432753 437552 446762 446813 447671 447849 448650 448862 451696 452372 452400 453316 453957 454785 455801 456832 457118 457936 466397 466542 466738 469181 469270 471193 474551 475277 477126 477575 479616 483048 486234 486751 488510 488551 489766 490040 491126 491465 494820 495221 496106 498077 499964 500453 505970 508957 511097 511392 516407 519215 520711 520872 522977 523142 525752 527416 528125 528406 528843 529279 549317 551137 556704 560242 560453 565889 567375 572304 572758 573196 580895 582346 583852 584007 587202 592959 614036 615812 627810 716675 730575 752517 789870 ] |
||||||||||||||||||||||||||||||
|
15.97 ms (8.00%) |
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 96955 730575 420126 423563 551137 528125 567375 418861 431421 520711 523142 382078 495221 587202 457118 483048 489766 486751 479616 451696 519215 520872 752517 448862 73421 437552 417849 432753 522977 418895 446813 457936 455801 491126 505970 474551 582346 389176 418866 452372 454785 486234 572758 471193 475277 488510 508957 511097 528843 560242 716675 580895 627810 466397 499964 572304 573196 560453 556704 425545 500453 494820 108054 413417 424535 490040 388542 453316 496106 146341 516407 592959 615812 386057 339770 16679 405716 418840 491465 565889 789870 469270 469181 477126 477575 447671 453957 207970 339474 397980 527416 466542 584007 447849 529279 614036 528406 488551 416297 418729 426809 428335 418547 414055 583852 549317 410180 425440 430309 21500 498077 525752 410954 446762 452400 448650 456832 511392 466738 423658 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.28%) |
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 16679 21500 73421 96955 108054 146341 207970 339474 339770 382078 386057 388542 389176 397980 405716 410180 410954 413417 414055 416297 417849 418547 418729 418840 418861 418866 418895 420126 423563 423658 424535 425440 425545 426809 428335 430309 431421 432753 437552 446762 446813 447671 447849 448650 448862 451696 452372 452400 453316 453957 454785 455801 456832 457118 457936 466397 466542 466738 469181 469270 471193 474551 475277 477126 477575 479616 483048 486234 486751 488510 488551 489766 490040 491126 491465 494820 495221 496106 498077 499964 500453 505970 508957 511097 511392 516407 519215 520711 520872 522977 523142 525752 527416 528125 528406 528843 529279 549317 551137 556704 560242 560453 565889 567375 572304 572758 573196 580895 582346 583852 584007 587202 592959 614036 615812 627810 716675 730575 752517 789870 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"члены мужчин подборка…"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член мужчин подборк"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.71%) |
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.