Query Metrics
7
Database Queries
7
Different statements
251.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
225.13 ms (89.51%) |
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 36844 198644 384317 390346 391147 391355 391395 399994 407426 421009 430559 454668 459314 461463 495070 510132 513063 523765 523777 525160 526451 528460 530826 531414 531499 536706 540370 545849 548489 564330 565291 571236 578459 579179 584651 585044 585107 587299 590414 592415 595252 595688 596993 611817 625831 625903 628065 630286 632766 632803 640321 654625 659502 659541 660544 661260 663477 665247 669130 669751 670985 671707 672110 673056 673151 673526 673974 675755 679706 684367 687665 690148 690810 690839 692813 693036 693882 694536 700660 703106 703111 704219 706193 710908 713055 713096 726384 727414 736053 737397 737554 740105 740204 740207 743129 744571 744899 745774 746262 754582 775420 775956 777450 785384 799411 809118 810220 813178 814335 815497 815583 816173 817112 817843 820975 821346 821665 827890 827910 827914 ] |
||||||||||||||||||||||||||||||
|
15.79 ms (6.28%) |
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 821665 827914 564330 669751 673151 692813 703111 710908 659541 660544 690148 694536 703106 713096 654625 665247 669130 670985 693036 706193 713055 590414 632803 625831 630286 611817 809118 777450 754582 744571 745774 740204 744899 727414 743129 746262 726384 740105 775420 799411 390346 384317 814335 454668 672110 523777 391147 495070 579179 545849 571236 578459 628065 595252 430559 198644 817843 531414 540370 513063 530826 523765 531499 671707 690810 673056 690839 548489 587299 632766 592415 596993 775956 740207 737397 785384 813178 391395 391355 407426 421009 526451 510132 528460 525160 585107 815583 693882 704219 663477 625903 640321 595688 810220 737554 736053 700660 461463 399994 817112 585044 816173 821346 815497 820975 827910 827890 36844 459314 536706 584651 565291 673526 679706 659502 661260 673974 675755 684367 687665 ] |
||||||||||||||||||||||||||||||
|
3.41 ms (1.36%) |
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 36844 198644 384317 390346 391147 391355 391395 399994 407426 421009 430559 454668 459314 461463 495070 510132 513063 523765 523777 525160 526451 528460 530826 531414 531499 536706 540370 545849 548489 564330 565291 571236 578459 579179 584651 585044 585107 587299 590414 592415 595252 595688 596993 611817 625831 625903 628065 630286 632766 632803 640321 654625 659502 659541 660544 661260 663477 665247 669130 669751 670985 671707 672110 673056 673151 673526 673974 675755 679706 684367 687665 690148 690810 690839 692813 693036 693882 694536 700660 703106 703111 704219 706193 710908 713055 713096 726384 727414 736053 737397 737554 740105 740204 740207 743129 744571 744899 745774 746262 754582 775420 775956 777450 785384 799411 809118 810220 813178 814335 815497 815583 816173 817112 817843 820975 821346 821665 827890 827910 827914 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty riding cock"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty riding cock"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty riding cock"
]
|
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.