Query Metrics
7
Database Queries
7
Different statements
188.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.10 ms (86.48%) |
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 411183 413294 418554 420432 423342 425529 425806 426657 427239 428305 428473 428919 432345 434332 435510 438656 439169 440710 444952 448579 451242 452353 452827 452915 453873 454155 455257 456939 464010 464258 464268 465909 466306 466842 469661 471104 471121 471656 472394 473719 475110 476382 477169 477244 479923 480641 481454 484337 486508 488757 488789 493283 494534 494545 494806 495278 495376 495546 496703 498393 499887 499909 509304 510541 511884 511890 518087 518505 521481 524646 525904 526938 527477 532920 540145 544861 546361 547748 549789 551768 552408 552761 558324 561969 561971 566607 567072 567873 568202 571095 572776 573283 573289 580018 581762 581917 582576 584322 584554 586027 590479 590713 595398 605791 617065 618020 624923 634711 715802 742326 749999 765803 770600 781767 783291 783983 799176 806995 809260 811125 ] |
||||||||||||||||||||||||||||||
|
16.30 ms (8.64%) |
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 471656 476382 464258 494806 558324 561971 584322 561969 566607 573289 552761 567873 584554 549789 567072 573283 605791 590713 595398 809260 770600 742326 432345 425806 439169 466306 427239 428305 454155 464268 411183 524646 526938 484337 495376 518505 495278 495546 518087 527477 540145 440710 428473 452827 452915 456939 471121 477244 451242 453873 466842 488789 472394 493283 498393 499887 494534 494545 477169 544861 552408 551768 581917 547748 568202 580018 582576 634711 806995 749999 781767 434332 448579 469661 481454 420432 426657 435510 444952 471104 425529 428919 473719 479923 413294 438656 452353 464010 465909 475110 455257 480641 499909 488757 496703 510541 511884 509304 423342 618020 617065 532920 571095 715802 486508 511890 799176 765803 783983 624923 525904 546361 572776 590479 811125 783291 418554 521481 581762 586027 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (1.71%) |
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 411183 413294 418554 420432 423342 425529 425806 426657 427239 428305 428473 428919 432345 434332 435510 438656 439169 440710 444952 448579 451242 452353 452827 452915 453873 454155 455257 456939 464010 464258 464268 465909 466306 466842 469661 471104 471121 471656 472394 473719 475110 476382 477169 477244 479923 480641 481454 484337 486508 488757 488789 493283 494534 494545 494806 495278 495376 495546 496703 498393 499887 499909 509304 510541 511884 511890 518087 518505 521481 524646 525904 526938 527477 532920 540145 544861 546361 547748 549789 551768 552408 552761 558324 561969 561971 566607 567072 567873 568202 571095 572776 573283 573289 580018 581762 581917 582576 584322 584554 586027 590479 590713 595398 605791 617065 618020 624923 634711 715802 742326 749999 765803 770600 781767 783291 783983 799176 806995 809260 811125 ] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation homemade"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.20 ms (0.64%) |
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.