Query Metrics
7
Database Queries
7
Different statements
154.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.63 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 397998 399151 417311 421516 427315 428578 430430 447793 451502 453123 453991 459251 459930 462595 463007 465306 475051 478376 479274 490484 503856 509655 509923 519856 521473 522518 523034 524740 527668 528160 528230 528394 529465 542859 543400 546111 546895 546904 546912 546922 554040 554296 554903 556472 558006 558224 560335 560827 561863 564381 565756 577990 579837 581921 582503 599524 604643 609214 614376 614419 615707 618468 619536 620042 628141 634849 636242 669514 678759 691462 699053 724836 727771 727789 728489 738834 741181 744436 747094 754158 756918 758284 758509 759950 760940 761230 763174 765317 766413 768469 770644 780745 782593 784206 784210 786179 788934 789491 791425 792664 794760 796919 797461 799352 801259 804609 805284 805462 807295 807329 807335 807338 807546 808228 808484 809522 814515 817258 825481 827262 ] |
||||||||||||||||||||||||||||||
|
16.81 ms (10.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 636242 614419 618468 780745 784210 799352 807295 788934 805462 809522 758284 766413 784206 786179 724836 728489 759950 763174 768469 738834 741181 747094 604643 789491 808484 427315 447793 428578 462595 451502 561863 417311 827262 817258 825481 453991 459251 490484 503856 528394 522518 524740 546904 556472 546912 546922 669514 678759 691462 564381 579837 634849 619536 796919 804609 808228 744436 758509 770644 794760 797461 805284 807546 754158 760940 727771 765317 727789 761230 756918 628141 791425 807338 399151 478376 397998 479274 430430 463007 521473 509655 527668 528160 528230 529465 421516 814515 453123 459930 509923 523034 519856 465306 475051 543400 546111 546895 554040 558224 565756 582503 542859 560827 554903 558006 560335 577990 581921 699053 554296 615707 614376 609214 620042 599524 782593 792664 801259 807329 807335 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.49%) |
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 397998 399151 417311 421516 427315 428578 430430 447793 451502 453123 453991 459251 459930 462595 463007 465306 475051 478376 479274 490484 503856 509655 509923 519856 521473 522518 523034 524740 527668 528160 528230 528394 529465 542859 543400 546111 546895 546904 546912 546922 554040 554296 554903 556472 558006 558224 560335 560827 561863 564381 565756 577990 579837 581921 582503 599524 604643 609214 614376 614419 615707 618468 619536 620042 628141 634849 636242 669514 678759 691462 699053 724836 727771 727789 728489 738834 741181 744436 747094 754158 756918 758284 758509 759950 760940 761230 763174 765317 766413 768469 770644 780745 782593 784206 784210 786179 788934 789491 791425 792664 794760 796919 797461 799352 801259 804609 805284 805462 807295 807329 807335 807338 807546 808228 808484 809522 814515 817258 825481 827262 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stepmom fucked"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stepmom fucked"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stepmom fucked"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.99%) |
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.