Query Metrics
7
Database Queries
7
Different statements
170.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.82 ms (83.19%) |
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 411861 412330 418458 420774 420816 426696 427339 429020 438207 439362 446251 450077 455640 467560 479867 493696 495800 499302 515531 529713 534443 534451 535294 538378 538395 539881 541265 541533 541541 544001 545242 545905 546972 553619 560345 560679 561954 561971 562587 563312 575860 575885 576534 577719 584031 584421 584481 585680 585863 586100 587306 587313 594230 594250 594363 595166 595194 595213 595581 596240 597691 600936 607891 632887 640081 640131 643159 644510 647530 650719 651731 662165 663749 679266 680815 682397 686331 689566 690630 692657 696960 702375 702376 704700 708226 713940 715244 727976 735297 744046 744047 745128 745915 751438 751546 751609 761246 766945 767731 779263 779280 780357 790109 791132 791376 791886 798591 802898 803367 803886 804140 806937 807219 808971 809660 812273 812374 814403 825478 827296 ] |
||||||||||||||||||||||||||||||
|
16.82 ms (9.87%) |
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 804140 499302 696960 809660 779263 643159 663749 735297 576534 541533 561971 745915 689566 594230 535294 539881 595213 455640 686331 446251 806937 702376 713940 702375 545242 727976 779280 575885 515531 534443 812374 808971 541541 600936 439362 495800 584031 650719 647530 827296 595166 546972 541265 594363 534451 803886 561954 640131 411861 584481 467560 493696 412330 450077 418458 595194 595581 651731 825478 607891 429020 690630 640081 586100 803367 767731 766945 791886 427339 529713 791132 585863 708226 538378 560345 692657 682397 553619 575860 751438 538395 798591 587306 715244 585680 751609 744047 680815 426696 420774 807219 438207 679266 780357 814403 563312 594250 791376 745128 704700 761246 790109 479867 596240 577719 584421 420816 545905 544001 587313 560679 597691 751546 662165 632887 812273 644510 802898 562587 744046 ] |
||||||||||||||||||||||||||||||
|
3.69 ms (2.16%) |
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 411861 412330 418458 420774 420816 426696 427339 429020 438207 439362 446251 450077 455640 467560 479867 493696 495800 499302 515531 529713 534443 534451 535294 538378 538395 539881 541265 541533 541541 544001 545242 545905 546972 553619 560345 560679 561954 561971 562587 563312 575860 575885 576534 577719 584031 584421 584481 585680 585863 586100 587306 587313 594230 594250 594363 595166 595194 595213 595581 596240 597691 600936 607891 632887 640081 640131 643159 644510 647530 650719 651731 662165 663749 679266 680815 682397 686331 689566 690630 692657 696960 702375 702376 704700 708226 713940 715244 727976 735297 744046 744047 745128 745915 751438 751546 751609 761246 766945 767731 779263 779280 780357 790109 791132 791376 791886 798591 802898 803367 803886 804140 806937 807219 808971 809660 812273 812374 814403 825478 827296 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bathroom riding dildo"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван riding дилд"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ван riding дилд"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.12%) |
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.