Query Metrics
7
Database Queries
7
Different statements
158.53 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.88 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.05 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy kissing"
]
|
||||||||||||||||||||||||||||||
| 3 | 17.79 ms |
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 485691 491878 501931 522883 554425 491208 817412 314118 396422 428477 434282 431117 457762 485759 531468 533802 493222 576691 541408 601063 607293 623817 439680 454080 469017 410642 470254 416098 435479 462483 431022 431376 491209 492323 430422 486963 493210 514820 516291 524951 535019 531441 563093 673960 549343 576720 612381 420925 471357 479020 431352 430570 474827 488734 485700 486835 492555 521342 460669 541661 541665 581112 541874 647642 609276 639760 439623 470248 484463 484973 472413 445436 524879 510286 574258 604161 521739 492602 483247 484519 533586 574538 502029 549246 431262 489112 538848 550662 554787 ] |
||||||||||||||||||||||||||||||
| 4 | 3.11 ms |
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 314118 396422 410642 416098 420925 428477 430422 430570 431022 431117 431262 431352 431376 434282 435479 439623 439680 445436 454080 457762 460669 462483 469017 470248 470254 471357 472413 474827 479020 483247 484463 484519 484973 485691 485700 485759 486835 486963 488734 489112 491208 491209 491878 492323 492555 492602 493210 493222 501931 502029 510286 514820 516291 521342 521739 522883 524879 524951 531441 531468 533586 533802 535019 538848 541408 541661 541665 541874 549246 549343 550662 554425 554787 563093 574258 574538 576691 576720 581112 601063 604161 607293 609276 612381 623817 639760 647642 673960 817412 ] |
||||||||||||||||||||||||||||||
| 5 | 130.34 ms |
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 314118 396422 410642 416098 420925 428477 430422 430570 431022 431117 431262 431352 431376 434282 435479 439623 439680 445436 454080 457762 460669 462483 469017 470248 470254 471357 472413 474827 479020 483247 484463 484519 484973 485691 485700 485759 486835 486963 488734 489112 491208 491209 491878 492323 492555 492602 493210 493222 501931 502029 510286 514820 516291 521342 521739 522883 524879 524951 531441 531468 533586 533802 535019 538848 541408 541661 541665 541874 549246 549343 550662 554425 554787 563093 574258 574538 576691 576720 581112 601063 604161 607293 609276 612381 623817 639760 647642 673960 817412 ] |
||||||||||||||||||||||||||||||
| 6 | 1.84 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая kissing"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.51 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая kissing"
]
|
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.