Query Metrics
7
Database Queries
7
Different statements
400.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.32 ms (53.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fat минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
154.49 ms (38.54%) |
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 285018 386638 388825 392754 392903 393754 400490 401202 401921 407270 408831 409958 418049 418400 419566 420565 425834 427218 428108 430188 431390 444903 445047 447251 447327 447750 455321 459492 460954 461416 471960 472275 473522 474910 476249 476300 476341 476353 478098 479766 481186 481214 483361 484316 486301 487351 491589 491762 492530 499187 502194 502578 503690 504574 508116 509030 510758 511259 513087 513581 513583 514418 514984 517276 518126 518982 520141 520296 520528 521657 523084 523861 524626 526205 527060 529493 530836 533000 543503 550423 556771 560831 563267 574414 587293 591349 593133 597268 597923 610202 626428 636463 644674 647617 650034 656407 659478 663524 663866 664280 665461 666095 667630 669776 695146 710668 725461 725537 740103 740300 744988 752151 758198 759687 770136 777284 781998 798608 800332 800533 ] |
||||||||||||||||||||||||||||||
|
17.05 ms (4.25%) |
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 418400 455321 533000 744988 401921 386638 392903 486301 518126 460954 667630 710668 560831 479766 514984 400490 530836 447750 461416 513087 647617 758198 471960 523084 526205 511259 520528 518982 520296 527060 656407 407270 430188 447327 521657 492530 418049 574414 476249 481214 666095 591349 427218 419566 502194 503690 524626 550423 659478 663866 665461 669776 597268 770136 781998 420565 459492 408831 509030 543503 587293 476341 481186 513583 514418 483361 491589 499187 597923 556771 644674 392754 445047 388825 431390 428108 447251 472275 476300 504574 473522 664280 610202 593133 800533 740300 759687 740103 800332 474910 476353 409958 502578 626428 484316 401202 663524 478098 520141 513581 695146 650034 563267 777284 798608 725461 752151 725537 444903 285018 529493 517276 510758 523861 393754 487351 508116 491762 636463 425834 ] |
||||||||||||||||||||||||||||||
|
9.17 ms (2.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fat минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
2.76 ms (0.69%) |
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 285018 386638 388825 392754 392903 393754 400490 401202 401921 407270 408831 409958 418049 418400 419566 420565 425834 427218 428108 430188 431390 444903 445047 447251 447327 447750 455321 459492 460954 461416 471960 472275 473522 474910 476249 476300 476341 476353 478098 479766 481186 481214 483361 484316 486301 487351 491589 491762 492530 499187 502194 502578 503690 504574 508116 509030 510758 511259 513087 513581 513583 514418 514984 517276 518126 518982 520141 520296 520528 521657 523084 523861 524626 526205 527060 529493 530836 533000 543503 550423 556771 560831 563267 574414 587293 591349 593133 597268 597923 610202 626428 636463 644674 647617 650034 656407 659478 663524 663866 664280 665461 666095 667630 669776 695146 710668 725461 725537 740103 740300 744988 752151 758198 759687 770136 777284 781998 798608 800332 800533 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fat blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.45%) |
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.