Query Metrics
7
Database Queries
7
Different statements
176.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.72 ms (86.37%) |
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 188262 366017 383514 392620 396378 396589 396617 397674 401688 401767 404738 405699 408502 409454 411701 412642 413073 413414 417612 420105 422767 423351 423864 424191 424228 424477 424487 425602 432318 435541 437176 437790 438005 438444 438615 442143 446630 446946 447018 449318 449676 452540 452780 453989 456899 457547 458069 458588 458891 459613 460300 461194 466448 467758 467935 468984 469322 471092 471493 472116 472334 473978 475600 479259 480112 488789 489324 490959 492438 494511 498200 500637 506110 514668 515839 517764 520117 520185 522152 523969 524701 526258 527623 527658 534552 535497 544001 548599 548634 549866 551604 552133 553611 557346 557940 562204 562209 566665 567035 567077 569527 570531 573583 574501 575102 576371 579210 598526 598821 601054 655078 655417 686331 692688 734345 735752 744930 770492 783316 798099 ] |
||||||||||||||||||||||||||||||
|
14.71 ms (8.32%) |
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 692688 573583 783316 452780 498200 392620 396378 396617 401688 405699 413414 411701 420105 461194 447018 488789 489324 446630 535497 490959 553611 557346 551604 569527 562204 562209 567077 655417 548634 570531 598821 601054 598526 798099 744930 770492 735752 366017 383514 449676 456899 458891 442143 458069 424228 424477 424487 438005 457547 459613 409454 435541 449318 468984 473978 480112 500637 523969 514668 517764 520117 526258 527658 655078 574501 467758 188262 396589 472116 417612 522152 506110 401767 404738 438444 453989 446946 460300 458588 494511 534552 552133 548599 544001 686331 734345 432318 438615 467935 472334 423864 437176 452540 471493 479259 424191 466448 475600 520185 527623 515839 492438 524701 408502 576371 567035 397674 413073 423351 425602 412642 422767 437790 471092 469322 549866 575102 557940 566665 579210 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.58%) |
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 188262 366017 383514 392620 396378 396589 396617 397674 401688 401767 404738 405699 408502 409454 411701 412642 413073 413414 417612 420105 422767 423351 423864 424191 424228 424477 424487 425602 432318 435541 437176 437790 438005 438444 438615 442143 446630 446946 447018 449318 449676 452540 452780 453989 456899 457547 458069 458588 458891 459613 460300 461194 466448 467758 467935 468984 469322 471092 471493 472116 472334 473978 475600 479259 480112 488789 489324 490959 492438 494511 498200 500637 506110 514668 515839 517764 520117 520185 522152 523969 524701 526258 527623 527658 534552 535497 544001 548599 548634 549866 551604 552133 553611 557346 557940 562204 562209 566665 567035 567077 569527 570531 573583 574501 575102 576371 579210 598526 598821 601054 655078 655417 686331 692688 734345 735752 744930 770492 783316 798099 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс сидя"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс сид"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.75%) |
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.