Query Metrics
7
Database Queries
7
Different statements
179.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.41 ms (82.83%) |
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 85949 233692 239599 382542 384033 387455 389693 391113 397135 405324 406973 407391 409390 411004 411262 412122 416233 417106 419371 421010 422034 423264 424321 425523 427475 427985 429757 430361 433497 443704 444212 444526 445515 446608 449435 451541 451748 452028 452377 452513 454046 455788 457101 459766 460567 460917 461244 461547 466138 467559 467979 470112 470604 477230 477346 477724 479401 483212 487718 487843 489409 489423 491535 493394 494394 496355 498236 498306 499998 500482 501767 501923 504183 510251 510398 511023 511154 512337 513390 513927 514019 515143 518284 520329 521251 521993 522529 528522 537402 538196 538226 547886 551649 552133 552588 554311 558843 559002 562361 563007 567810 567890 574781 575456 582811 595818 597559 602506 606695 621980 636111 655097 655358 657667 657680 658269 659703 710301 716586 781747 ] |
||||||||||||||||||||||||||||||
|
20.64 ms (11.52%) |
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 387455 411004 459766 499998 528522 412122 547886 444212 512337 538196 477346 554311 461244 567810 460917 522529 606695 454046 567890 411262 419371 477230 537402 657667 655097 491535 433497 421010 449435 455788 483212 498306 423264 710301 457101 510251 538226 500482 504183 513927 382542 406973 444526 425523 597559 384033 515143 405324 427475 466138 430361 595818 451541 407391 496355 552588 657680 563007 427985 452377 489423 574781 575456 552133 559002 659703 494394 409390 479401 446608 513390 514019 518284 493394 487718 520329 558843 636111 429757 460567 470112 511154 498236 501767 397135 487843 510398 389693 424321 452028 602506 511023 551649 391113 501923 489409 443704 467559 470604 452513 582811 416233 233692 658269 621980 562361 461547 467979 521251 417106 781747 716586 451748 239599 422034 85949 521993 477724 655358 445515 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.56%) |
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 85949 233692 239599 382542 384033 387455 389693 391113 397135 405324 406973 407391 409390 411004 411262 412122 416233 417106 419371 421010 422034 423264 424321 425523 427475 427985 429757 430361 433497 443704 444212 444526 445515 446608 449435 451541 451748 452028 452377 452513 454046 455788 457101 459766 460567 460917 461244 461547 466138 467559 467979 470112 470604 477230 477346 477724 479401 483212 487718 487843 489409 489423 491535 493394 494394 496355 498236 498306 499998 500482 501767 501923 504183 510251 510398 511023 511154 512337 513390 513927 514019 515143 518284 520329 521251 521993 522529 528522 537402 538196 538226 547886 551649 552133 552588 554311 558843 559002 562361 563007 567810 567890 574781 575456 582811 595818 597559 602506 606695 621980 636111 655097 655358 657667 657680 658269 659703 710301 716586 781747 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс с другим партнёром"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс друг парен"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс друг парен"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.