Query Metrics
7
Database Queries
7
Different statements
162.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.85 ms (83.50%) |
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 187353 187843 233617 358193 365875 367962 384128 389757 391344 391651 391923 391955 392004 392019 397850 400892 401843 411321 411350 411820 415753 415782 424032 424449 425997 433341 433353 436138 439634 439722 439758 439856 440639 441000 441280 441359 443292 445397 452931 453348 454399 454560 459951 461039 462348 464975 466314 466877 468269 468369 469390 472007 474109 476349 478384 478450 482490 484373 485870 485943 485970 489105 495444 498422 498702 514488 514761 516480 521220 523834 526737 530474 532271 535587 591833 592904 593044 663866 665366 665448 669776 714510 725185 726486 726502 727032 727507 733148 734822 735888 736219 738462 739608 739962 740958 741506 741752 741784 741787 741794 742274 743786 747054 748391 758283 761046 761056 761164 768366 788300 788542 788546 792670 796072 796566 796807 799351 799962 808241 826267 ] |
||||||||||||||||||||||||||||||
|
16.86 ms (10.36%) |
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 727507 734822 747054 748391 768366 725185 738462 741787 743786 758283 735888 736219 739608 739962 741506 742274 761164 714510 796807 391923 461039 358193 462348 391651 411350 474109 384128 187843 187353 389757 401843 415782 433341 411820 826267 482490 535587 514761 532271 459951 665448 593044 592904 788300 788542 799351 741752 741784 741794 788546 796072 796566 740958 761046 733148 726486 727032 761056 792670 799962 233617 391955 464975 468369 478384 365875 454560 391344 433353 526737 485870 485970 489105 498702 516480 514488 521220 523834 392019 400892 441359 425997 441280 415753 440639 454399 468269 472007 452931 530474 495444 466314 663866 665366 669776 591833 808241 726502 424032 424449 445397 453348 478450 392004 436138 367962 485943 484373 498422 441000 476349 443292 469390 411321 439634 439758 439856 397850 439722 466877 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.59%) |
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 187353 187843 233617 358193 365875 367962 384128 389757 391344 391651 391923 391955 392004 392019 397850 400892 401843 411321 411350 411820 415753 415782 424032 424449 425997 433341 433353 436138 439634 439722 439758 439856 440639 441000 441280 441359 443292 445397 452931 453348 454399 454560 459951 461039 462348 464975 466314 466877 468269 468369 469390 472007 474109 476349 478384 478450 482490 484373 485870 485943 485970 489105 495444 498422 498702 514488 514761 516480 521220 523834 526737 530474 532271 535587 591833 592904 593044 663866 665366 665448 669776 714510 725185 726486 726502 727032 727507 733148 734822 735888 736219 738462 739608 739962 740958 741506 741752 741784 741787 741794 742274 743786 747054 748391 758283 761046 761056 761164 768366 788300 788542 788546 792670 796072 796566 796807 799351 799962 808241 826267 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature chubby doggy"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature chubby рак"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature chubby рак"
]
|
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.