API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 21st, 2022
16
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 32.92 KB | None | 0 0
raw download clone embed print report
  1. Url: "/product-category/fashion-3/women-fashion-3/?wpsolr_fq[0]=product_cat_str%3AFashion&wpsolr_fq[1]=product_cat_str%3AWomen&wpsolr_fq[2]=product_cat_str%3AWomen%20Bags&wpsolr_fq[3]=product_cat_str%3ATotes"
  2. Index: "new_index"
  3. Nb results shown: 20
  4. Total nb results: 1085
  5. Speed: 713 ms
  6. Query: {
  7. "from": 0,
  8. "size": 20,
  9. "_source": [
  10. "id",
  11. "PID",
  12. "type",
  13. "meta_type_s",
  14. "title",
  15. "numcomments",
  16. "comments",
  17. "displaydate",
  18. "displaymodified",
  19. "*categories_str",
  20. "author",
  21. "*post_thumbnail_href_str",
  22. "*post_href_str",
  23. "snippet_s"
  24. ],
  25. "query": {
  26. "function_score": {
  27. "functions": [
  28. {
  29. "filter": {
  30. "match": {
  31. "product_cat_str": "Smartphones"
  32. }
  33. },
  34. "weight": 3
  35. },
  36. {
  37. "filter": {
  38. "match": {
  39. "product_cat_str": "Smartwatch Accessories"
  40. }
  41. },
  42. "weight": 2.5
  43. },
  44. {
  45. "filter": {
  46. "match": {
  47. "product_cat_str": "Grocery"
  48. }
  49. },
  50. "weight": 7
  51. },
  52. {
  53. "filter": {
  54. "match": {
  55. "product_cat_str": "eggs"
  56. }
  57. },
  58. "weight": 1
  59. },
  60. {
  61. "filter": {
  62. "match": {
  63. "product_brand_str": "Hugo Boss"
  64. }
  65. },
  66. "weight": 2
  67. },
  68. {
  69. "filter": {
  70. "match": {
  71. "product_brand_str": "Aamrai"
  72. }
  73. },
  74. "weight": 4
  75. },
  76. {
  77. "filter": {
  78. "match": {
  79. "product_brand_str": "Del Monte"
  80. }
  81. },
  82. "weight": 3
  83. },
  84. {
  85. "filter": {
  86. "match": {
  87. "product_brand_str": "Crest"
  88. }
  89. },
  90. "weight": 3
  91. },
  92. {
  93. "filter": {
  94. "match": {
  95. "author": "italist"
  96. }
  97. },
  98. "weight": 3
  99. }
  100. ],
  101. "query": {
  102. "bool": {
  103. "must": {
  104. "query_string": {
  105. "fields": [
  106. "title^5",
  107. "content^2",
  108. "product_cat_str^10",
  109. "product_brand_str",
  110. "author"
  111. ],
  112. "query": "(*)",
  113. "default_operator": "AND"
  114. }
  115. },
  116. "filter": {
  117. "bool": {
  118. "must": [
  119. {
  120. "bool": {
  121. "must_not": [
  122. {
  123. "terms": {
  124. "post_status_s": [
  125. "draft",
  126. "pending",
  127. "trash",
  128. "future",
  129. "private",
  130. "auto-draft"
  131. ]
  132. }
  133. }
  134. ]
  135. }
  136. },
  137. {
  138. "bool": {
  139. "must": {
  140. "term": {
  141. "non_flat_hierarchy_product_cat_str": "Women"
  142. }
  143. }
  144. }
  145. },
  146. {
  147. "bool": {
  148. "should": [
  149. {
  150. "bool": {
  151. "must_not": [
  152. {
  153. "terms": {
  154. "type": [
  155. "product"
  156. ]
  157. }
  158. }
  159. ]
  160. }
  161. },
  162. {
  163. "bool": {
  164. "should": [
  165. {
  166. "bool": {
  167. "must_not": [
  168. {
  169. "exists": {
  170. "field": "product_visibility_str"
  171. }
  172. }
  173. ]
  174. }
  175. },
  176. {
  177. "bool": {
  178. "must_not": [
  179. {
  180. "terms": {
  181. "product_visibility_str": [
  182. "exclude-from-catalog"
  183. ]
  184. }
  185. }
  186. ]
  187. }
  188. }
  189. ]
  190. }
  191. }
  192. ]
  193. }
  194. },
  195. {
  196. "bool": {
  197. "should": [
  198. {
  199. "bool": {
  200. "must_not": [
  201. {
  202. "terms": {
  203. "type": [
  204. "product"
  205. ]
  206. }
  207. }
  208. ]
  209. }
  210. },
  211. {
  212. "terms": {
  213. "product_stock_str": [
  214. "y"
  215. ]
  216. }
  217. }
  218. ]
  219. }
  220. },
  221. {
  222. "bool": {
  223. "should": [
  224. {
  225. "bool": {
  226. "must_not": [
  227. {
  228. "bool": {
  229. "must": {
  230. "exists": {
  231. "field": "is_excluded_s"
  232. }
  233. }
  234. }
  235. }
  236. ]
  237. }
  238. },
  239. {
  240. "terms": {
  241. "is_excluded_s": [
  242. "n"
  243. ]
  244. }
  245. }
  246. ]
  247. }
  248. },
  249. {
  250. "bool": {
  251. "must_not": [
  252. {
  253. "terms": {
  254. "_id": [
  255. "wpsolr_doc_id_attachment"
  256. ]
  257. }
  258. }
  259. ]
  260. }
  261. }
  262. ]
  263. }
  264. }
  265. }
  266. }
  267. }
  268. },
  269. "post_filter": {
  270. "bool": {
  271. "must": [
  272. {
  273. "bool": {
  274. "must": [
  275. {
  276. "terms": {
  277. "type": [
  278. "product"
  279. ]
  280. }
  281. }
  282. ]
  283. }
  284. }
  285. ]
  286. }
  287. },
  288. "aggs": {
  289. "_price_f": {
  290. "filter": {
  291. "bool": {
  292. "must": [
  293. {
  294. "bool": {
  295. "must": [
  296. {
  297. "terms": {
  298. "type": [
  299. "product"
  300. ]
  301. }
  302. }
  303. ]
  304. }
  305. }
  306. ]
  307. }
  308. },
  309. "aggs": {
  310. "_price_f": {
  311. "filter": {
  312. "match_all": {}
  313. },
  314. "aggs": {
  315. "_price_f": {
  316. "stats": {
  317. "field": "_price_f"
  318. }
  319. }
  320. }
  321. }
  322. }
  323. },
  324. "product_brand_str": {
  325. "filter": {
  326. "bool": {
  327. "must": [
  328. {
  329. "bool": {
  330. "must": [
  331. {
  332. "terms": {
  333. "type": [
  334. "product"
  335. ]
  336. }
  337. }
  338. ]
  339. }
  340. }
  341. ]
  342. }
  343. },
  344. "aggs": {
  345. "product_brand_str": {
  346. "filter": {
  347. "match_all": {}
  348. },
  349. "aggs": {
  350. "product_brand_str": {
  351. "terms": {
  352. "field": "product_brand_str",
  353. "size": 20
  354. }
  355. }
  356. }
  357. }
  358. }
  359. },
  360. "pa_gender_str": {
  361. "filter": {
  362. "bool": {
  363. "must": [
  364. {
  365. "bool": {
  366. "must": [
  367. {
  368. "terms": {
  369. "type": [
  370. "product"
  371. ]
  372. }
  373. }
  374. ]
  375. }
  376. }
  377. ]
  378. }
  379. },
  380. "aggs": {
  381. "pa_gender_str": {
  382. "filter": {
  383. "match_all": {}
  384. },
  385. "aggs": {
  386. "pa_gender_str": {
  387. "terms": {
  388. "field": "pa_gender_str",
  389. "size": 20
  390. }
  391. }
  392. }
  393. }
  394. }
  395. },
  396. "pa_color_str": {
  397. "filter": {
  398. "bool": {
  399. "must": [
  400. {
  401. "bool": {
  402. "must": [
  403. {
  404. "terms": {
  405. "type": [
  406. "product"
  407. ]
  408. }
  409. }
  410. ]
  411. }
  412. }
  413. ]
  414. }
  415. },
  416. "aggs": {
  417. "pa_color_str": {
  418. "filter": {
  419. "match_all": {}
  420. },
  421. "aggs": {
  422. "pa_color_str": {
  423. "terms": {
  424. "field": "pa_color_str",
  425. "size": 20
  426. }
  427. }
  428. }
  429. }
  430. }
  431. },
  432. "pa_health-facts_str": {
  433. "filter": {
  434. "bool": {
  435. "must": [
  436. {
  437. "bool": {
  438. "must": [
  439. {
  440. "terms": {
  441. "type": [
  442. "product"
  443. ]
  444. }
  445. }
  446. ]
  447. }
  448. }
  449. ]
  450. }
  451. },
  452. "aggs": {
  453. "pa_health-facts_str": {
  454. "filter": {
  455. "match_all": {}
  456. },
  457. "aggs": {
  458. "pa_health-facts_str": {
  459. "terms": {
  460. "field": "pa_health-facts_str",
  461. "size": 20
  462. }
  463. }
  464. }
  465. }
  466. }
  467. },
  468. "pa_artisana_str": {
  469. "filter": {
  470. "bool": {
  471. "must": [
  472. {
  473. "bool": {
  474. "must": [
  475. {
  476. "terms": {
  477. "type": [
  478. "product"
  479. ]
  480. }
  481. }
  482. ]
  483. }
  484. }
  485. ]
  486. }
  487. },
  488. "aggs": {
  489. "pa_artisana_str": {
  490. "filter": {
  491. "match_all": {}
  492. },
  493. "aggs": {
  494. "pa_artisana_str": {
  495. "terms": {
  496. "field": "pa_artisana_str",
  497. "size": 20
  498. }
  499. }
  500. }
  501. }
  502. }
  503. },
  504. "flat_hierarchy_product_cat_str": {
  505. "filter": {
  506. "bool": {
  507. "must": [
  508. {
  509. "bool": {
  510. "must": [
  511. {
  512. "terms": {
  513. "type": [
  514. "product"
  515. ]
  516. }
  517. }
  518. ]
  519. }
  520. }
  521. ]
  522. }
  523. },
  524. "aggs": {
  525. "flat_hierarchy_product_cat_str": {
  526. "filter": {
  527. "match_all": {}
  528. },
  529. "aggs": {
  530. "flat_hierarchy_product_cat_str": {
  531. "terms": {
  532. "field": "flat_hierarchy_product_cat_str",
  533. "size": 20
  534. }
  535. }
  536. }
  537. }
  538. }
  539. }
  540. }
  541. }
  542. "aggregations": {
  543. "product_brand_str": {
  544. "doc_count": 1085,
  545. "product_brand_str": {
  546. "doc_count": 1085,
  547. "product_brand_str": {
  548. "doc_count_error_upper_bound": 0,
  549. "sum_other_doc_count": 183,
  550. "buckets": [
  551. {
  552. "key": "Pronovias",
  553. "doc_count": 121
  554. },
  555. {
  556. "key": "Karl Lagerfeld",
  557. "doc_count": 71
  558. },
  559. {
  560. "key": "Indietales",
  561. "doc_count": 66
  562. },
  563. {
  564. "key": "Just Cavalli",
  565. "doc_count": 51
  566. },
  567. {
  568. "key": "Timberland",
  569. "doc_count": 45
  570. },
  571. {
  572. "key": "Versace",
  573. "doc_count": 42
  574. },
  575. {
  576. "key": "SprayGround",
  577. "doc_count": 35
  578. },
  579. {
  580. "key": "Armani Exchange",
  581. "doc_count": 33
  582. },
  583. {
  584. "key": "Allure Bridals",
  585. "doc_count": 31
  586. },
  587. {
  588. "key": "N.E.A.T by Nicky",
  589. "doc_count": 31
  590. },
  591. {
  592. "key": "New Balance",
  593. "doc_count": 29
  594. },
  595. {
  596. "key": "Tom Ford",
  597. "doc_count": 29
  598. },
  599. {
  600. "key": "Nine West",
  601. "doc_count": 27
  602. },
  603. {
  604. "key": "Tommy Hilfiger",
  605. "doc_count": 25
  606. },
  607. {
  608. "key": "Salvatore Ferragamo",
  609. "doc_count": 24
  610. },
  611. {
  612. "key": "St. Patrick",
  613. "doc_count": 24
  614. },
  615. {
  616. "key": "Rosa Clar\u00e1",
  617. "doc_count": 21
  618. },
  619. {
  620. "key": "White One",
  621. "doc_count": 21
  622. },
  623. {
  624. "key": "Carriwell",
  625. "doc_count": 17
  626. },
  627. {
  628. "key": "C\u00e9line",
  629. "doc_count": 17
  630. }
  631. ]
  632. }
  633. }
  634. },
  635. "pa_artisana_str": {
  636. "doc_count": 1085,
  637. "pa_artisana_str": {
  638. "doc_count": 1085,
  639. "pa_artisana_str": {
  640. "doc_count_error_upper_bound": 0,
  641. "sum_other_doc_count": 0,
  642. "buckets": [
  643. {
  644. "key": "Artisana products",
  645. "doc_count": 24
  646. }
  647. ]
  648. }
  649. }
  650. },
  651. "pa_health-facts_str": {
  652. "doc_count": 1085,
  653. "pa_health-facts_str": {
  654. "doc_count": 1085,
  655. "pa_health-facts_str": {
  656. "doc_count_error_upper_bound": 0,
  657. "sum_other_doc_count": 0,
  658. "buckets": []
  659. }
  660. }
  661. },
  662. "_price_f": {
  663. "doc_count": 1085,
  664. "_price_f": {
  665. "doc_count": 1085,
  666. "_price_f": {
  667. "count": 1094,
  668. "min": 22,
  669. "max": 89351.8515625,
  670. "avg": 4021.8725515780543,
  671. "sum": 4399928.571426392
  672. }
  673. }
  674. },
  675. "pa_gender_str": {
  676. "doc_count": 1085,
  677. "pa_gender_str": {
  678. "doc_count": 1085,
  679. "pa_gender_str": {
  680. "doc_count_error_upper_bound": 0,
  681. "sum_other_doc_count": 0,
  682. "buckets": [
  683. {
  684. "key": "Women",
  685. "doc_count": 79
  686. }
  687. ]
  688. }
  689. }
  690. },
  691. "flat_hierarchy_product_cat_str": {
  692. "doc_count": 1085,
  693. "flat_hierarchy_product_cat_str": {
  694. "doc_count": 1085,
  695. "flat_hierarchy_product_cat_str": {
  696. "doc_count_error_upper_bound": 0,
  697. "sum_other_doc_count": 306,
  698. "buckets": [
  699. {
  700. "key": "Fashion",
  701. "doc_count": 1085
  702. },
  703. {
  704. "key": "Fashion->Women",
  705. "doc_count": 1085
  706. },
  707. {
  708. "key": "Fashion->Women->Women Clothing",
  709. "doc_count": 580
  710. },
  711. {
  712. "key": "Fashion->Women->Women Clothing->Wedding Dress",
  713. "doc_count": 245
  714. },
  715. {
  716. "key": "Fashion->Women->Eyewear",
  717. "doc_count": 196
  718. },
  719. {
  720. "key": "Fashion->Women->Women Bags",
  721. "doc_count": 182
  722. },
  723. {
  724. "key": "Fashion->Women->Women Clothing->Dresses",
  725. "doc_count": 137
  726. },
  727. {
  728. "key": "Fashion->Women->Eyewear->Sunglasses",
  729. "doc_count": 135
  730. },
  731. {
  732. "key": "Fashion->Women->Women Shoes",
  733. "doc_count": 83
  734. },
  735. {
  736. "key": "Fashion->Women->Women Bags->Totes",
  737. "doc_count": 66
  738. },
  739. {
  740. "key": "Fashion->Women->Eyewear->Eyeglasses",
  741. "doc_count": 61
  742. },
  743. {
  744. "key": "Fashion->Women->Women Bags->Cross body bags",
  745. "doc_count": 40
  746. },
  747. {
  748. "key": "Fashion->Women->Women Bags->Fashion backpacks",
  749. "doc_count": 32
  750. },
  751. {
  752. "key": "Fashion->Women->Women Shoes->Sneakers",
  753. "doc_count": 27
  754. },
  755. {
  756. "key": "Fashion->Women->Women Clothing->Sportswear",
  757. "doc_count": 25
  758. },
  759. {
  760. "key": "Fashion->Women->Women Clothing->Tops",
  761. "doc_count": 22
  762. },
  763. {
  764. "key": "Fashion->Women->Women Clothing->Jeans",
  765. "doc_count": 21
  766. },
  767. {
  768. "key": "Fashion->Women->Jewellery",
  769. "doc_count": 19
  770. },
  771. {
  772. "key": "Fashion->Women->Women Accessories",
  773. "doc_count": 19
  774. },
  775. {
  776. "key": "Fashion->Women->Women Shoes->Pumps",
  777. "doc_count": 19
  778. }
  779. ]
  780. }
  781. }
  782. },
  783. "pa_color_str": {
  784. "doc_count": 1085,
  785. "pa_color_str": {
  786. "doc_count": 1085,
  787. "pa_color_str": {
  788. "doc_count_error_upper_bound": 0,
  789. "sum_other_doc_count": 203,
  790. "buckets": [
  791. {
  792. "key": "White",
  793. "doc_count": 167
  794. },
  795. {
  796. "key": "Black",
  797. "doc_count": 109
  798. },
  799. {
  800. "key": "Ivory",
  801. "doc_count": 30
  802. },
  803. {
  804. "key": "Brown",
  805. "doc_count": 29
  806. },
  807. {
  808. "key": "Pink",
  809. "doc_count": 24
  810. },
  811. {
  812. "key": "Blue",
  813. "doc_count": 23
  814. },
  815. {
  816. "key": "Clear\/Havana",
  817. "doc_count": 22
  818. },
  819. {
  820. "key": "Natural White",
  821. "doc_count": 21
  822. },
  823. {
  824. "key": "Red",
  825. "doc_count": 21
  826. },
  827. {
  828. "key": "Clear\/Black",
  829. "doc_count": 19
  830. },
  831. {
  832. "key": "Grey\/Black",
  833. "doc_count": 18
  834. },
  835. {
  836. "key": "Navy Blue",
  837. "doc_count": 14
  838. },
  839. {
  840. "key": "Beige",
  841. "doc_count": 12
  842. },
  843. {
  844. "key": "Green",
  845. "doc_count": 12
  846. },
  847. {
  848. "key": "Silver",
  849. "doc_count": 12
  850. },
  851. {
  852. "key": "Multicolor",
  853. "doc_count": 10
  854. },
  855. {
  856. "key": "Nude",
  857. "doc_count": 10
  858. },
  859. {
  860. "key": "Purple",
  861. "doc_count": 9
  862. },
  863. {
  864. "key": "Blue\/Silver",
  865. "doc_count": 8
  866. },
  867. {
  868. "key": "Grey",
  869. "doc_count": 8
  870. }
  871. ]
  872. }
  873. }
  874. }
  875. }
  876. }
  877.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!