Query Metrics
7
Database Queries
7
Different statements
147.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.18 ms (83.09%) |
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 7196 382051 383641 387636 388803 390994 391275 394636 395552 395674 395727 401127 404939 404952 407357 419064 424362 426032 426197 429763 431412 434443 435391 436718 443364 445493 448552 451572 452843 453358 453825 457163 459395 460222 468626 469764 473387 474610 488805 494151 497805 499111 500300 503673 507646 509805 509875 515892 522283 522899 523312 530249 530798 531174 531230 533517 536253 536650 537925 537933 545407 545416 550669 564407 565241 565243 589761 595209 599002 599306 601559 601635 603628 617408 617412 629333 630221 632699 633818 635900 640783 641628 641986 642000 645001 645327 647928 647937 649192 649497 658777 672711 673526 675021 676624 678517 679728 680151 683963 687362 702675 704235 708525 716868 720385 720708 723494 741277 741542 742135 744103 744744 745928 748539 749990 752630 777052 808327 823721 ] |
||||||||||||||||||||||||||||||
|
15.80 ms (10.75%) |
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 390994 391275 401127 404952 426032 436718 429763 419064 452843 448552 459395 497805 494151 523312 530798 509875 537933 550669 545407 545416 649192 647937 672711 645327 647928 633818 599002 617408 632699 601559 603628 595209 807580 741542 808327 745928 617412 702675 473387 383641 395727 424362 435391 460222 7196 407357 474610 488805 530249 453358 531174 704235 635900 630221 434443 499111 645001 716868 382051 742135 387636 658777 723494 599306 744744 673526 404939 431412 426197 443364 457163 468626 522899 531230 533517 515892 536650 537925 509805 565243 649497 678517 679728 675021 676624 565241 589761 629333 641986 642000 601635 640783 741277 720708 395552 445493 395674 451572 469764 500300 522283 503673 507646 564407 708525 641628 777052 744103 752630 720385 388803 453825 536253 680151 823721 749990 394636 687362 683963 748539 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.57%) |
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 7196 382051 383641 387636 388803 390994 391275 394636 395552 395674 395727 401127 404939 404952 407357 419064 424362 426032 426197 429763 431412 434443 435391 436718 443364 445493 448552 451572 452843 453358 453825 457163 459395 460222 468626 469764 473387 474610 488805 494151 497805 499111 500300 503673 507646 509805 509875 515892 522283 522899 523312 530249 530798 531174 531230 533517 536253 536650 537925 537933 545407 545416 550669 564407 565241 565243 589761 595209 599002 599306 601559 601635 603628 617408 617412 629333 630221 632699 633818 635900 640783 641628 641986 642000 645001 645327 647928 647937 649192 649497 658777 672711 673526 675021 676624 678517 679728 680151 683963 687362 702675 704235 708525 716868 720385 720708 723494 741277 741542 742135 744103 744744 745928 748539 749990 752630 777052 808327 823721 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen double penetration"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen double penetration"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen double penetration"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.08%) |
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.